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
sqlcommand cmd = new sqlcommand("select id from emp ; select
dptid from dpt",YourConnection);
//check connection status and open the connection
//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
|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 connection pooling and what is the maximum pool size in ado.net connection string?
Explain how can we load multiple tables in to dataset?
What is the difference between Dataset. clone and Dataset.copy?
What are the different ado.net namespaces are available in .net?
can anybody show me the structure of ADO.NET
what are the differences between dataset and datareader?
Define the data provider classes that is supported by ado.net?
What are the Different layers in ADO.Net?
What is the difference between DataReader and DataSet in ADO.NET?
What is ado.net object model?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is the use of SqlCommandBuilder?