C#

monuSaini wrote:

I had define connection string using wizard.

costavo wrote:

how to add data from database table to the combobox,
where i want to read a certain feild and when selected an other feild would be written in somewhere else

SqlConnection dbConn = new SqlConnection ("connectionstring");<br />
            dbConn.Open ();<br />
            SqlDataAdapter da = new SqlDataAdapter ("SELECT town FROM Table", dbConn);<br />
            da.Fill (ds);<br />
<br />
            DropDownList1.DataSource = ds.Table[0];<br />
            DropDownList1.DataBind ();

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

costavo wrote:

please would u give a code example

<br />
SqlConnection dbConn = new SqlConnection(connectionString);<br />
<br />
dbConn.Open();<br />
<br />
SqlDataAdapter da = new SqlDataAdapter("SELECT town,postal FROM table1", dbConn);<br />
DataSet ds = new DataSet();<br />
da.Fill(ds);<br />
<br />
dbConn.Close();<br />
<br />
DropDownList1.DataSource = ds.Tables[0];<br />
DropDownList1.DataTextField = "town";<br />
DropDownList1.DataValueField = "postalcode";<br />
DropDownList1.DataBind();

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.