All Forums

Getting started with new database

2013-05-25T12:26:11.69-04:00

Suppose i have one table in my database. Its about markeing purpose and data enttry kind work.

i am importing data from MBD's into tabale...

Table contains approx 90 miliion records, contains duplicate record..

table has date of file created.

Just need to select data and show in grid view... with parameters.

Parameters can ne anything.

How to allow float numbers upto two decimal places in textbox??

2013-05-24T17:28:57.973-04:00

Hi,

I want to create one textbox which can take float numbers as input upto two decimal places,how it can be done by javascript as i am not able to do so

Please help me.???

Thanks in advance

File Download Link

2013-05-25T12:42:16.273-04:00

Hi...I am using ASP.Net MVC. I want to make a file download link. i.e. when someone clicks that link, a specific file downloading should be started.

How to get to label1.text the list of comma separated values

2013-05-25T08:20:05.127-04:00

I have a sqldatasource displaying a list like this

Name | Amount
====|=======
Mr A, 30
Mr B, 20
C, 40
D, 60
etc

How to display it in label1.text

A=30, B=20, C=40, D=60

... etc ?

Just pure text is okay, I will not use it as further parameter in another query.

Thanks

Reducing server hits from GridView?

2013-05-25T12:39:03.26-04:00

I just started using GridView and it's pretty darn slick. One thing I don't like, is that every operation requires a server hit. I'm not worried about the load on the server, but I don't like the responsiveness from the user's point of view.

Is there a way to use GridView such that it does all its magic client-side, and then when the user hits the form submit it sends all its edited data at once?

Thanks,

Chris

label font colour as per data

2013-05-25T09:56:57.427-04:00

i have two labels in my asp.net+vb web page. label1 and label2

if label1.text value is less than label2.text then label1.text font colour should be red else black

Imagebuttom ispostback

2013-05-25T12:07:43.793-04:00

hi
I am a beginner in ASP.net

I want to use imagebuttom
my problem as I click the image I want to change the image without reloading the page. is that you can help me

page asp.aspx

<asp:ImageButton ID="img1" runat="server" ImageUrl="/imgs/faitmain_0.PNG" width="111" height="111"   OnClientClick="img1_Click;return false;" />


page aspx.vb





Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load



End Sub



Protected Sub img1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles img1.Click



If Not Page.IsPostBack Then





If img1.ImageUrl = "imgs/faitmain_0.PNG" Then

' img1.OnClientClick = "return false;"'

img1.ImageUrl = imgs/faitmain_1.PNG"
'img1.PostBackUrl = "imgs/faitmain_1.PNG"

Else





img1.ImageUrl = "/imgs/faitmain_0.PNG"

End If



End Sub

I made SEVERAL solutions but still same problem: the page reloads

How to Use list of gridview in single page asp.net

2013-05-25T12:22:24.373-04:00

I am doing student project, here I want to view all Student Rollno based on Attendance

i want to view more than 10 Gridview on same page

About RowDatabound

2013-05-25T11:35:29.17-04:00

Hi all:

I am wondering if rowdatabaund fires only first time record is linked to a gridview, for example. Or every time, including postbacks.

Thans for any help

Required Column Value as Column Name

2013-05-25T06:25:56.283-04:00

Please Help !!!

I Have 3 Tables in Sql Server 2005 let say Table1, Table2, Table3 with data view as follows:-

1) Table1

--------------------------
MenuID MenuName
--------------------------
200 Masters
201 Transactions
--------------------------

2) Table2

--------------------------
UserID Uname
--------------------------
U0010 John
U0011 Ram
--------------------------

3) Table3

------------------------------------------------------
RightsID MenuID UserID Allow
------------------------------------------------------
1 200 U0010 True
2 201 U0010 False
3 200 U0011 True
4 201 U0011 True
------------------------------------------------------

Now my requirement is to show output as follows:-

------------------------------------------------------
MenuID MenuName John Ram
------------------------------------------------------
200 Masrters True True
201 Transactions False True
------------------------------------------------------

Please Help !!!!!

Thanks In advance...

Data Pager + Update Panel

2013-05-25T12:25:37.277-04:00

I need help, I have a DataPager inside the update panel and and working well, but when I refresh page or going on back button form some other page datapager reset always to the first page.

For example if I was on the tenth page and refresh page, data pager reset to first.

Is there any way to keep the current page on data pager?

My code is:

<asp:SqlDataSource ID="SqlDataSource1" EnableCaching="True" CacheDuration="4000" CacheExpirationPolicy="Sliding"
runat="server" ConnectionString="<%$ ConnectionStrings:blabla %>" SelectCommand=""></asp:SqlDataSource>

<asp:UpdatePanel ID="UpdatePanelnajgornji" runat="server" >
<ContentTemplate>
<asp:ListView ID="ListView1"  runat="server" ondatabound="ListView1_DataBound" DataSourceID="SqlDataSource1">
<ItemTemplate>
<asp:HyperLink ID="HyperLink2" Visible='<%# !(Eval("Slika") is DBNull) %>' runat="server" NavigateUrl='<%# Eval("Link") %>' title='<%# Eval("Naslov") %>'>
<asp:Image ID="Image1" runat="server" AlternateText='<%# Eval("Naslov") %>' ImageUrl='<%# Eval("Slika") %>' /></asp:HyperLink>
</ItemTemplate>
</asp:ListView>
<br />
    <asp:DataPager ID="DataPager1" runat="server" PagedControlID="ListView1">
        <Fields>
            <asp:NextPreviousPagerField />
        </Fields>
    </asp:DataPager>

</ContentTemplate>
</asp:UpdatePanel>

Gridview creation in asp .net

2013-05-25T07:02:42.523-04:00

How should i assigned dattable columns name to gridview of first columns of row depending on how much i want to assign it to gridview and display values of that column name in next columns of gridview

Please help me for that

I have datacolumns name as per gridview rows in first column name and i have values like AL,S,H,M any one of them for one perticular values pleasehelp me for that....!

Creating gridview from json data string

2013-05-24T20:01:11.483-04:00

Okay I searched and searched but I keep hitting a dead end...

I am getting a string of json data back from an api call to a third party website. Here is an example of what it looks like:

{"results":[{"bioguide_id":"L000563","chamber":"house","first_name":"Daniel","last_name":"Lipinski"},{"bioguide_id":"K000360","chamber":"senate","first_name":"Mark","last_name":"Kirk"},{"bioguide_id":"D000563","chamber":"senate","first_name":"Richard","last_name":"Durbin"}],"count":3,"page":{"count":3,"per_page":20,"page":1}}

I want to extract the chamber, first name and last name from this json data and display it in a gridview. I have been trying to figure the json.net library and have it successfully added to my site. But for the life of me I cannot figure out how to get the array of these names out of the json and into a something I can turn into a gridview. All examples of using json.net are in c# and I unfortunately am working in VB... Any help and examples would be greatly appreciated.

asp.net roles how to create manual on my server 2008

2013-05-25T11:23:06.567-04:00

Hi,

how to create roles in sql server 2008?
I tried manual to insert in the table aspnet_Roles and aspnet_UsersInRoles but does not works.

aspnet_Roles:
ApplicationId   RoleId   RoleName   LoweredRoleName   Description
E5B03A74-3514-45F1-8644-F69FE756358D   44FAEFAC-AB48-449F-8AA7-F2050863BF36   admin   admin   NULL

aspnet_UsersInRoles:
UserId   RoleId
EE65F09E-E20F-4EBE-A3C9-0F4A62B41545   44FAEFAC-AB48-449F-8AA7-F2050863BF36

aspnet_Membership:
ApplicationId   UserId   Password   PasswordFormat   PasswordSalt   MobilePIN   Email   LoweredEmail   PasswordQuestion   PasswordAnswer   IsApproved   IsLockedOut   CreateDate   LastLoginDate   LastPasswordChangedDate   LastLockoutDate   FailedPasswordAttemptCount   FailedPasswordAttemptWindowStart   FailedPasswordAnswerAttemptCount   FailedPasswordAnswerAttemptWindowStart   Comment
E5B03A74-3514-45F1-8644-F69FE756358D   EE65F09E-E20F-4EBE-A3C9-0F4A62B41545   I4rEmGcHzrJv58KD42Qoh9j9TZ8=   1   8VnqjKXh4+UUTAUtSFel1A==   NULL   admin@    admin@    NULL   NULL   1   0   2013-05-25 11:13:19.000   2013-05-25 11:21:27.003   2013-05-25 11:13:19.000   1754-01-01 00:00:00.000   0   1754-01-01 00:00:00.000   0   1754-01-01 00:00:00.000   NULL

web.config:
<system.web>
    <authorization>
      <allow roles="Admin" />
      <deny users="*" />
    </authorization>
</system.web>

Localhost works but I use asp.net Configuration

Please help

Why validation work unnecessary which stop form unnecessary

2013-05-25T04:50:39.977-04:00

Hi,

I was using validation in gridview in which i have textbox and its required field validator in each row,If i left blank textbox and i submit page by button click then validation error meassage is fired then if i put value in textbox and click submit button validation disappears and it don't submit the form, and then i click 3rd time it submit form,Why is it so why we can not submit form on second time,How to tackle all this???Please help me

Thanks

How to read / display Tweets from my Twitter Account

2013-05-24T12:36:11.837-04:00

Hi,

Please can anyone direct me to any article or coding example of reading / displaying tweets from twitter account onto my webpage

Don't want to use Embedded Timelines Widget from Twitter

Thanks in advance

Fire Javascript event while closing chrome browser

2013-05-23T12:07:16.653-04:00

Hi All,

I tried many ways to fire the event while closing the chrome browser since my application got some security issues due to the new option "Continue where is left off"

$(window).unload(function () {

if (event.clientY < 0) {

alert("123");

}

noting get worked except the below but my custom event not getting fired to clear the session cookie

window.onbeforeunload = check;

function check()

{

return "Are you sure you want to exit this page?";

//or put whatever function you need to call when a user closes the web //browser.

}

Please any one tell me the idea to clear session cookie by a program.

Thanks

I need to fetch the modified data in database from access, every 5 min.

2013-05-25T11:31:58.887-04:00

Hai

I need to fetch the modified data in database from access, every 5 min. in windows app.

i.e

I hav one mdb which having data they modfiy every min.

i wanna to fetch those datas in my database . which are all modified.

Jquery Json.. Saveing data into file for autocomplete

2013-05-25T10:36:15.37-04:00

Hi i have some diffrent requirement..

i want to save json data for autocomplete control of Jquery..

want to save new enrties made my user into that file.. cant use database.. its a small project based on HTML,Css and Javascript..

only requirement is of autocomplete...

how to write Query in Sql

2013-05-25T10:47:56.97-04:00

        select srno,Buildingtype,NoOfBuilding from EleBuildingGroupMst

        current 1 10 10
        i want below result

        1, 10 Bulid->10 Floor->10

    want display dropdownlist this type record