String strConnString = ConfigurationManager.ConnectionStrings["AntronERP_DBConnectionString2"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Search Customer";
cmd.Parameters.Add("@cusCode", SqlDbType.NChar).Value = txtcusCode.Text.Trim();
cmd.Parameters.Add("@Status", SqlDbType.Int).Value = 0;
cmd.Connection = con;
try
{
con.Open();
DropDown_Customer.DataSource = cmd.ExecuteReader();
DropDown_Customer.DataTextField = "cusName";
DropDown_Customer.DataValueField = "cusCode";
DropDown_Customer.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}