problem in writing query for particular problem..
-
can any one help me i am facing problem in writing query in my project.i am taking four link buttons in one page(test.aspx page) when i click on Test1 link it should show me the result on show page (show.aspx page) by retriving the data stored in database for Test1 table similarly if i click Test2 link it should show me the data on same show page(show.aspx page) retriving data from database for test2 table same for Test3 and Test4 link.database iam using here is sql server 2005.
-
can any one help me i am facing problem in writing query in my project.i am taking four link buttons in one page(test.aspx page) when i click on Test1 link it should show me the result on show page (show.aspx page) by retriving the data stored in database for Test1 table similarly if i click Test2 link it should show me the data on same show page(show.aspx page) retriving data from database for test2 table same for Test3 and Test4 link.database iam using here is sql server 2005.
How it's displayed and how the user interacts with it doesn't matter. What database system? What is your schema like?
-
can any one help me i am facing problem in writing query in my project.i am taking four link buttons in one page(test.aspx page) when i click on Test1 link it should show me the result on show page (show.aspx page) by retriving the data stored in database for Test1 table similarly if i click Test2 link it should show me the data on same show page(show.aspx page) retriving data from database for test2 table same for Test3 and Test4 link.database iam using here is sql server 2005.
Trap the click event from the buttons Identify the button Test1-4 to determine the table Create a query string to select the data based on the button clicked Create a connection to the database Create a command using the connection string and the query string that returns a data table bind the datatable to the grin in your UI
Never underestimate the power of human stupidity RAH
-
Trap the click event from the buttons Identify the button Test1-4 to determine the table Create a query string to select the data based on the button clicked Create a connection to the database Create a command using the connection string and the query string that returns a data table bind the datatable to the grin in your UI
Never underestimate the power of human stupidity RAH
-
@mycroftholmes can u plzz write query for me to retrive data from diffrent tables on a single pages.
Nope, I have better things to do that your work. [edit] I relent
Select * from TableName
there you go, just replace tableName with the table name. [/edit]
Never underestimate the power of human stupidity RAH