public void batch() { SqlDataAdapter da = new SqlDataAdapter("addmarks_proc", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.AddWithValue("@action", "batch"); da.SelectCommand.Parameters.AddWithValue("@pk_id", ""); da.SelectCommand.Parameters.AddWithValue("@batch", ""); da.SelectCommand.Parameters.AddWithValue("@stream", ""); da.SelectCommand.Parameters.AddWithValue("@examterm", ""); da.SelectCommand.Parameters.AddWithValue("@class", ""); da.SelectCommand.Parameters.AddWithValue("@section", ""); da.SelectCommand.Parameters.AddWithValue("@subject", ""); da.SelectCommand.Parameters.AddWithValue("@student_name", ""); da.SelectCommand.Parameters.AddWithValue("@roll_no", ""); da.SelectCommand.Parameters.AddWithValue("@obtain_marks", ""); da.SelectCommand.Parameters.AddWithValue("@maximum_marks", ""); da.SelectCommand.Parameters.AddWithValue("@comment", ""); DataTable dt = new DataTable(); da.Fill(dt); Batch_dll.DataSource = dt; Batch_dll.DataTextField = "batch"; Batch_dll.DataValueField = "batch_id"; Batch_dll.DataBind(); Batch_dll.Items.Insert(0, "Select Batch"); }
public void batch() { SqlDataAdapter da = new SqlDataAdapter("Select * from batch_tbl", con); DataTable dt = new DataTable(); da.Fill(dt); Batch_dll.DataSource = dt; Batch_dll.DataTextField = "batch"; Batch_dll.DataValueField = "batch_id"; Batch_dll.DataBind(); Batch_dll.Items.Insert(0, "Select Batch"); }
public void batch() { SqlDataAdapter da = new SqlDataAdapter("addfee_proc", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.AddWithValue("@action", "batch"); da.SelectCommand.Parameters.AddWithValue("@pk_id", ""); da.SelectCommand.Parameters.AddWithValue("@batch", ""); da.SelectCommand.Parameters.AddWithValue("@stream", ""); da.SelectCommand.Parameters.AddWithValue("@class", ""); da.SelectCommand.Parameters.AddWithValue("@section", ""); da.SelectCommand.Parameters.AddWithValue("@feetype", ""); da.SelectCommand.Parameters.AddWithValue("@date", ""); da.SelectCommand.Parameters.AddWithValue("@fee", ""); DataTable dt = new DataTable(); da.Fill(dt); Batch_dll.DataSource = dt; Batch_dll.DataTextField = "batch"; Batch_dll.DataValueField = "batch_id"; Batch_dll.DataBind(); Batch_dll.Items.Insert(0, "Select Batch"); }