protected void Page_Load(object sender, EventArgs e) { SqlConnection sqlobj = new SqlConnection("Data Source = 182.18.175.64 ; Initial Catalog = TamilnaduForestDept ; Login = ***** ; Password = *****; Integrated Security = True"); string sel = "select Status_CommonID,Status_CommonName,Active_Status,EntryBy,EntryDate from Mst_Status_Common"; sqlobj.Open(); SqlDataAdapter adp = new SqlDataAdapter(sel, sqlobj); DataSet ds = new DataSet(); adp.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ddl_StatusCommon.Items.Add(ds.Tables[0].Rows[i].ItemArray[0].ToString()); } } protected void ddl_StatusCommon_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection sqlobj = new SqlConnection("Data Source = 182.18.175.64 ; Initial Catalog = TamilnaduForestDept ; Login = ******; Password = *****; Integrated Security = True"); string sel = "select Status_CommonId,Status_CommonName,Active_Status,EntryBy,EntryDate from office where Status_CommonId = '" + ddl_StatusCommon.SelectedItem.ToString() + "'"; sqlobj.Open(); SqlDataAdapter adp = new SqlDataAdapter(sel, sqlobj); DataSet ds = new DataSet(); adp.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ddl_StatusCommon.Items.Add(ds.Tables[0].Rows[i].ItemArray[0].ToString()); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)