unable to access the information from the database
-
Hello, I have made two tables in SQL server : one is tblogin and 2nd is Details. i want to have the information in the details view in the web form which is opened after successfull login .And that information must be correspondent to the login form.
-
Hello, I have made two tables in SQL server : one is tblogin and 2nd is Details. i want to have the information in the details view in the web form which is opened after successfull login .And that information must be correspondent to the login form.
Sounds so trivial that you don't even need to write code to do it. Why can't you do it ? What have you tried ?
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
Sounds so trivial that you don't even need to write code to do it. Why can't you do it ? What have you tried ?
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
In login web form, i have bound login database, In another web form that opens after successful login, i have bound "details" database. and. login database have 1 PK cloumn i.e. UserId which is the foreign Key column in details table... Now , I want to access the information from the details table from UserId corresponding to Id of the login table . i mean ,form must always show the details of the ID that has been logged in, from the details table that is bound the web form
-
In login web form, i have bound login database, In another web form that opens after successful login, i have bound "details" database. and. login database have 1 PK cloumn i.e. UserId which is the foreign Key column in details table... Now , I want to access the information from the details table from UserId corresponding to Id of the login table . i mean ,form must always show the details of the ID that has been logged in, from the details table that is bound the web form
OK - so it sounds like perhaps you need to write your own SQL to achieve what you want ? Do you know anything about SQL ? Do you know how to use ADO.NET to connect to a database ? Although I said you can probably do it without writing code, the fact is that no professional solution would work that way.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
In login web form, i have bound login database, In another web form that opens after successful login, i have bound "details" database. and. login database have 1 PK cloumn i.e. UserId which is the foreign Key column in details table... Now , I want to access the information from the details table from UserId corresponding to Id of the login table . i mean ,form must always show the details of the ID that has been logged in, from the details table that is bound the web form
-
In login web form, i have bound login database, In another web form that opens after successful login, i have bound "details" database. and. login database have 1 PK cloumn i.e. UserId which is the foreign Key column in details table... Now , I want to access the information from the details table from UserId corresponding to Id of the login table . i mean ,form must always show the details of the ID that has been logged in, from the details table that is bound the web form
During Login process place a sessionkey of current userid into session from User table. If you details Id is UserId you can easily fetch from session : "SELECT * FROM DETAILS WHERE ID = " + Session["UserID"] Use SqlCommand object to fire the query and get the output. Finally Bind the output with any UIElement you want to . :) Before you do any code read about ADO.NET first so that you know what you are doing. You might follow this link : ADO.NET Tutorial[^] :)
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml> -
In login web form, i have bound login database, In another web form that opens after successful login, i have bound "details" database. and. login database have 1 PK cloumn i.e. UserId which is the foreign Key column in details table... Now , I want to access the information from the details table from UserId corresponding to Id of the login table . i mean ,form must always show the details of the ID that has been logged in, from the details table that is bound the web form
Make ur fundas strong in Sql and ADO.net , otherwise Developement would be a big headache for you
-
Sounds so trivial that you don't even need to write code to do it. Why can't you do it ? What have you tried ?
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
hi, There are many ways to do this, like as you should bind your detailsview through login session, so that only login user details will be display
Farogh Haider Web developer