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(); }