private void GET_DDL_DATA_WS()
{
string m_sqlstr = "SELECT '' as WS union SELECT DISTINCT ws FROM STK_ChemDAta where depa='" + DDL_depa.SelectedValue.ToString() + "' Order By ws Asc ";
using (SqlConnection DDL_strCon = new SqlConnection(M_connstr))
{
try
{
SqlCommand dropdownlist_cmd = new SqlCommand();
dropdownlist_cmd.Connection = DDL_strCon;
dropdownlist_cmd.CommandText = m_sqlstr;
DDL_strCon.Open();
SqlDataReader ddl = dropdownlist_cmd.ExecuteReader();
DDL_WS.DataValueField = "ws";
DDL_WS.DataTextField = "ws";
DDL_WS.DataSource = ddl;
DDL_WS.DataBind();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message.ToString() + "');</script>");
}
finally
{
DDL_strCon.Close();
DDL_strCon.Dispose();
}
}
}
private void GET_DDL_DATA_WS()
{
string m_sqlstr = "SELECT wsno from STK_WS Order By wsno ";
using (SqlConnection DDL_strCon = new SqlConnection(M_connstr))
{
try
{
SqlCommand dropdownlist_cmd = new SqlCommand();
dropdownlist_cmd.Connection = DDL_strCon;
dropdownlist_cmd.CommandText = m_sqlstr;
DDL_strCon.Open();
SqlDataReader ddl = dropdownlist_cmd.ExecuteReader();
DDL_WS.DataValueField = "wsno";
DDL_WS.DataTextField = "wsno";
DDL_WS.DataSource = ddl;
DDL_WS.DataBind();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message.ToString() + "');</script>");
}
finally
{
DDL_strCon.Close();
DDL_strCon.Dispose();
}
}
}