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

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

Answer / ak

It is simple


if(reader.hasrows)
{
combo1.additem(reader[0])
combo2.additem(reader[1])
}

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

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

About ADO and its objects ?

1 Answers   DELL,

---

Why is ADO.NET serialization slower than ADO ?

0 Answers   NA,

---

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

0 Answers  

---

What is the default provider in ado.net?

0 Answers  

---

How does ado.net work?

0 Answers  

---

---

What is fill method in ado.net?

0 Answers  

---

Explain how can we load multiple tables in to dataset?

0 Answers  

---

How you will set the datarelation between two columns?

3 Answers  

---

Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,

---

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,

---

On ODP.net ?

1 Answers   MMTS,

---

What is ole2 format?

0 Answers  

---