event handling of dynamically created checkboxes in a dynamic table

[isha610]

In my project, initially, i am submitting which year,division and subject (of students) i want to access in the student database. Once i click the submit button, dynamic checkboxes are created in a dynamic table according to the query submited above. However i am facing a problem while accessing/event handling these checkboxes to update the attendance of students for the above submited subject back into the database! please help!

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;


namespace iso_generator
{
    public partial class attendance : System.Web.UI.Page
    {

        CheckBox cb1;
        System.Data.OleDb.OleDbConnection con;
        System.Data.OleDb.OleDbDataAdapter da;
        System.Data.DataSet ds;

        static int inc = -1;
        static int maxRows;
      
        


       protected void Page_Load(object sender, EventArgs e)
        {
            con = new System.Data.OleDb.OleDbConnection();
            con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ISO\\DB\\db1.mdb";
            con.Open();


            string division = ddlDivision.Text;
            string year = ddlYear.Text;
            string subj = ddlSubject.Text;

            String query = "select * from student " +
                "where syear = '" + year + "' AND div ='" + division + "' order by roll";

            da = new System.Data.OleDb.OleDbDataAdapter(query, con);
            ds = new DataSet();
            da.Fill(ds, "student");
            maxRows = ds.Tables["student"].Rows.Count;


           


        }

        protected void ATTENDANCE_SUBMIT_Click(object sender, EventArgs e)
        {
           
            // Create a new HtmlTable object.
            HtmlTable table1 = new HtmlTable();
            table1.ID = ("YOURID");

            // Set the table's formatting-related properties.
            table1.Border = 1;
            table1.CellPadding = 1;
            table1.CellSpacing = 1;
            table1.BorderColor = "red";

            // Start adding content to the table.
            HtmlTableRow row;
            HtmlTableCell cell;
            int i = 0;


            for (int m = 0; m < 10; m++)
            {
                // Create a new row and set its background color.
                row = new HtmlTableRow();
                row.BgColor = "lightyellow";
                for (int j = 0; j < 5; j++)
                {
                    if (i < maxRows)
                    {
                        // Create a cell and set its text.
                        DataRow dRow;
                        dRow = ds.Tables["student"].Rows[i];

                        cb1 = new CheckBox();
                  cb1.Checked = false;

                        cb1.ID = "" + dRow.ItemArray.GetValue(0).ToString();   //setting gr no to chechked box id//
                        cb1.Text = dRow.ItemArray.GetValue(2).ToString() + " : " +
                            dRow.ItemArray.GetValue(1).ToString();
                        cb1.Height = 50;
                        cb1.AutoPostBack = true;
                        cb1.CheckedChanged += new EventHandler
                                           (cb1_CheckedChanged);

                        cell = new HtmlTableCell();

                        cell.Controls.Add(cb1);
                        // Add the cell to the current row.
                        row.Cells.Add(cell);
                        i++;
                    }

                }

                // Add the row to the table.
                table1.Rows.Add(row);
            }

            // Add the table to the page.
            //this.Controls.Add(table1);
          
            form1.Controls.Add(table1);




        }

        protected void cb1_CheckedChanged
                (object sender, EventArgs e)
        {
            string marks;
            if (cb1.Checked)
            {

                DataRow drow = ds.Tables["student"].Rows[0];  //go  to 1st row of database//
                string variable = drow.ItemArray.GetValue(0).ToString(); //get 1st student GR_NO value in variable//

                for (inc = 0; variable != cb1.ID; inc++)  //scan from 1st student GR_NO till the NON-CHECKED chckbox student GR_NO IN DATABASE//
                {
                    drow = ds.Tables["student"].Rows[inc];
                    variable = drow.ItemArray.GetValue(0).ToString();
                }

                if (ddlSubject.Text == "SUB1")
                {
                    marks = drow.ItemArray.GetValue(7).ToString();   //7TH COLUMN IN DATABASE IS SUBJECT1 COLUMN//
                    marks = marks + 1;                //INCREMENT THE ATTENDANCE BY 1//
                    drow[7] = marks;
                }
                        
            
            }
               
        }
}