Beispiel #1
0
    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");
    }
Beispiel #2
0
    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");
    }
Beispiel #3
0
    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");
    }