protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
const string dbConnectionString = @"Data Source=DATABAIST;Database=ksingh31;Integrated Security=true";
SqlConnection dbConnection = new SqlConnection();
dbConnection.ConnectionString = dbConnectionString;
dbConnection.Open();
SqlCommand getItemCmd = new SqlCommand();
getItemCmd.Connection = dbConnection;
getItemCmd.CommandType = CommandType.StoredProcedure;
getItemCmd.CommandText = "GetItem";
SqlDataAdapter da = new SqlDataAdapter(getItemCmd);
DataSet itemC = new DataSet();
da.Fill(itemC);
ItemCodeList.DataSource = itemC;
ItemCodeList.DataTextField = "ItemCode";
ItemCodeList.DataValueField = "ItemCode";
ItemCodeList.DataBind();
ItemCodeList.Items.Insert(0, new ListItem("-- Select Item Code --", "0"));
dbConnection.Close();
}
}
public void dropdownItem()
{
const string dbConnectionString = @"Data Source=DATABAIST;Database=ksingh31;Integrated Security=true";
SqlConnection dbConnection = new SqlConnection();
dbConnection.ConnectionString = dbConnectionString;
dbConnection.Open();
SqlCommand getItemCmd = new SqlCommand();
getItemCmd.Connection = dbConnection;
getItemCmd.CommandType = CommandType.StoredProcedure;
getItemCmd.CommandText = "GetItem";
SqlDataAdapter da = new SqlDataAdapter(getItemCmd);
DataSet itemC = new DataSet();
da.Fill(itemC);
ItemCodeList.DataSource = itemC;
ItemCodeList.DataTextField = "ItemCode";
ItemCodeList.DataValueField = "ItemCode";
ItemCodeList.DataBind();
ItemCodeList.Items.Insert(0, new ListItem("-- Select Item Code --", "0"));
dbConnection.Close();
}
