Can we bind one datareader wid two dropdown list?
Answers were Sorted based on User's Feedback
Answer / pradip humane
Yes,we can bind the one datareader with two dropdownlist.
because datareader just read the data and forward the
data,that's why there is no problem for binding with two
dropdown list with one reader
| Is This Answer Correct ? | 16 Yes | 4 No |
Answer / anup kumar
yes, it is posible. by using NextResult() method of
sqldatareader.
sqlcommand cmd = new sqlcommand("select id from emp ; select
dptid from dpt",YourConnection);
//check connection status and open the connection
if(rdr.hasrows)
{
//read id from emp
}
if (rdr.HasRows() == true)
{
//read dptid from dpt
}
//close the connection
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ak
It is simple
if(reader.hasrows)
{
combo1.additem(reader[0])
combo2.additem(reader[1])
}
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / rmishra
We can bind the same Datareader to different drop downs but
the constraint is that it will show the same data for both
the dropdown ie if the datareader fetches the city data for
one dropdown then it will show the same data for second one
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / vivek
data reader has no multiple binding because when it is
binded to multiple controls navigation problem
araises.because it is forward only.
so,multiple binding is perfectly possible with dataset only
| Is This Answer Correct ? | 0 Yes | 4 No |
What is main five diffrent between Connected And Disconnected environment
15 Answers HCL, Satyam, US India, Wipro,
What is difference between datagridview and datagrid control in winforms?
Give an example that shows how to execute a stored procedure in ado.net?
How to perform sorting on a table in ADO.NET?
0 Answers Petranics Solutions,
What is data relation?
What is XML serialization
What is sqlconnection and sqlcommand?
What is the difference between ado.net and entity framework?
Explain the ADO . Net Architecture ?
What is datasource in ado.net?
What are dcl commands?
What is ole db and odbc?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)