how can add checked list box checked item as status of attendance in php mysql database

See more:

C#

Hello Dear programer(s)
i developing the c# attendance application and this application data saved in the php-mysql.
i have one table attendance which saves data about new student and one table for save attendance named "absent_student" and its field is semester,course,division,date,rollno,name and status.i first selecting all data according to course semester and division field(column)using combobox from attendance table and inserting in absent_student table but date and status adding after the new column using following code after clicking on button.
The date is properly adding but status add using value of checkedlistbox
this not properly added.
(code)

private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                con = new MySqlConnection(constring);
                cmdabsent = new MySqlCommand("SELECT sem,course,division,rollno,name FROM attendance WHERE course='" + coursecombo + "' AND sem='" + semcombo + "' AND division='" + divcombo + "'", con);
                MySqlDataAdapter dafillabsent = new MySqlDataAdapter(cmdabsent);
                MySqlCommandBuilder cmdbul = new MySqlCommandBuilder(dafillabsent);
                DataSet dsfillabsent = new DataSet();
                dsfillabsent.Clear();
                dafillabsent.Fill(dsfillabsent, "AllAbsent");
                dsfillabsent.Tables["AllAbsent"].Columns.Add(new DataColumn("date"));
                dsfillabsent.Tables["AllAbsent"].Columns.Add(new DataColumn("status"));
                CheckedListBox.CheckedItemCollection o = checkedListBox1.CheckedItems;
                for(int i=0;i<=Convert.ToInt32(total)-1;i++)
                {
                    dsfillabsent.Tables["AllAbsent"].Rows[i]["date"] = Convert.ToDateTime(dateTimePicker1.Value);
                    if (o.Contains(i))
                    {
                        dsfillabsent.Tables["AllAbsent"].Rows[i]["status"] = "A";
                    }
                    else
                    {
                        dsfillabsent.Tables["AllAbsent"].Rows[i]["status"] = "P";
                    }
                }

                    //dafillabsent.Update(dsfillabsent.Tables["AllAbsent"]);


                    dataGridView1.DataSource = dsfillabsent.Tables["AllAbsent"];
            }
            catch (Exception ex)
            {
                MessageBox.Show("ERROR: " + ex, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

please suggest me.
wait for answer
Thank you.