how to old data to new data retrive data base to create set (lesson despatch)in c#

hi
 
this is the code  
 
private void btnSubmit_Click(object sender, System.EventArgs e)
        {
            Dbcom.CommandType =CommandType.StoredProcedure;
            Dbcom.CommandText ="sp_newsetcreated";
            Dbcom.Connection=Dbcon ;
            Dbcom.Connection.Open ();
            Dbcom.Parameters.Clear ();
           
////            Response.Write("insert into newsetcreated(Coursecode,Year,Medium,sets,Date)values('"+ DblCourseName.SelectedItem.Value +"','"+ dplyear.SelectedItem.Text +"','" ...