----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Kantha Message 3 in Discussion string ConStr = "server=(local);database= northwind";<o:p></o:p> SqlConnection SqlCon = new SqlConnection(ConStr);<o:p></o:p> SqlCon.Open();<o:p></o:p> string strdropdownlist = "select column1 from tablename";<o:p></o:p> SqlDataAdapter dalist = new SqlDataAdapter(strdropdownlist,SqlCon);<o:p></o:p> DataSet ds = new DataSet();<o:p></o:p> dalist.Fill(ds , "tablename");<o:p></o:p> DropDownList1.DataTextField = "Column";<o:p></o:p> DropDownList1.DataSource = ds.Tables["table1"];<o:p></o:p> DropDownList1.DataBind();<o:p></o:p> <o:p> </o:p> Hope the above code helps.<o:p></o:p> <o:p> </o:p> Regards<o:p></o:p> KanthaLakshmi<o:p></o:p> <o:p> </o:p> From: Amshuman [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 2:16 AM To: <st1:PersonName w:st="on">BDOTNET</st1:PersonName> Subject: Drop down list problem...URGENT!!!<o:p></o:p> <o:p> </o:p> <o:p></o:p> <o:p></o:p> New Message on BDOTNET<o:p></o:p> <o:p></o:p> <o:p> </o:p> Drop down list problem...URGENT!!!<o:p></o:p> Reply <o:p></o:p> <o:p></o:p> Reply to Sender Recommend <o:p></o:p> Message 1 in Discussion <o:p></o:p> <o:p></o:p> From: Amshuman <o:p></o:p> Hi, I'm using the following code to populate a drop down list box in c#.. SqlConnection con = new SqlConnection(....); SqlDataAdapter da = new SqlDataAdapter(....); DataSet ds = new DataSet(); da.Fill(ds, "table1"); DataDownList1.DataSource = ds.Tables["table1"]; DataDownList1.DataBind(); The problem is that the drop down list box isn't populated with the data. Instead, it's populated with text "System.Data.Common.DbDataRecordView". Please give me a solution for the above. Thanks in advance, Amshuman<o:p></o:p> <o:p></o:p> View other groups in this category. language="JavaScript" type="text/javascript"> document.write(''); </script> ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
