Dear All,
May i know how to display a Data in Textbox when Select in Dropdownlist ?
protected void WMItem_SelectedIndexChanged(object sender, EventArgs e)
{
QueryDetTBL.Visible = true;
string ItemType = WMItemType.SelectedValue;
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CIMProRPT01ConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT ITEM ,DESCRIPTION,ITEM_TYPE FROM [CIMProRPT01].[dbo].[WM_MASTER] WHERE ITEM_TYPE ='" + ItemType + "'", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
WMItem.DataSource = ds;
WMItem.DataTextField = "ITEM";
...
Go to the complete details ...