DataTable shippers = new DataTable();
using (SqlConnection con = new SqlConnection(connectionString))
{
try
{
SqlDataAdapter adapter = new SqlDataAdapter("Select Temp_Name,Temp_Code from Temp_Shipper", con);
adapter.Fill(shippers);
ddlshipper.DataSource = shippers;
ddlshipper.DataTextField = "Temp_Name";
ddlshipper.DataValueField = "Temp_Code";
ddlshipper.DataBind();
}
catch (Exception ex)
{
}
}
ddlSubject.Items.Insert(0, new ListItem("<Select Shipper>", "0"));
Now handle SelectedIndexChanged Event of DropDown and assign the value to TextBox.
void Shipper_Index_Changed(Object sender, EventArgs e)
{
textbox8.Text = ddlshipper.SelectedItem.Value;
}
Markup of
DropDownList
is like...
<asp:DropDownList id="ddlshipper" runat="server" AutoPostBack="True" OnSelectedIndexChanged="Shipper_Index_Changed">
</asp:DropDownList>