Click here to Skip to main content
12,951,732 members (65,605 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
i m maintaning two data base tables
table1 for the drop down it contains some id's like : infosys by clicking the infosys it should check with the table 2 and generate the employees for infosys all details in grid view. how its possible.
Posted 31-Dec-12 18:17pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

string strsql=string.empty;
strsql="select * from table2 where id1=@dropdownvalue1";
//write code for executing a query
cmd.parameter.addwithvalue(@dropdownvalue1,dropdownlistvalue1);
//write code for filling dataset here
if(ds.Tables[0].rows.count>0)
{
//bound gridview here
}
 



Thanks
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 1 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100