C#,how to get the seven day data to save in table?

Question

Hi

I am Having 7 Days form with Particular field including date,day,time.

am getting the data to store in sql table,database through the form.

While am Selecting 7 days using calendar to entry the record in the form ,

its saving only the 7Th day record,1-6 day records not store in database table?

HOW TO CLEAR THE ERROR ?

Ex:

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cp"].ConnectionString; cnn.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select * from tbl_sch111";

cmd.Connection = cnn;

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataSet ds = new DataSet();

da.Fill(ds, "tbl_sch111");

SqlCommandBuilder cb = new SqlCommandBuilder(da);

DataRow drow = ds.Tables["tbl_sch111"].NewRow();

drow["Date"] = lb.Text=l.Text;

drow["Time"] = lbb.Text= l2.Text;

drow["Day"] = lbd.Text= l3.Text;

drow["blk_1"] = txtbl1.Text= TextBox1.Text;

drow["blk_2"] = txtbl2.Text= TextBox2.Text;

drow["blk_3"] = txtbl3.Text= TextBox3.Text;

drow["blk_4"] = txtbl4.Text= TextBox4.Text;

drow["blk_5"] = txtbl5.Text= TextBox5.Text;

drow["blk_6"] = txtbl6.Text= TextBox6.Text;

drow["blk_7"] = txtbl7.Text= TextBox7.Text;

drow["blk_8"] = txtbl8.Text= TextBox8.Text;

drow["blk_9"] = txtbl9.Text= TextBox9.Text;

drow["blk_10"] = txtbl10.Text= TextBox10.Text;

ds.Tables["tbl_sch111"].Rows.Add(drow);

da.Update(ds, "tbl_sch111");