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