protected void btnSave_Click(object sender, EventArgs e)

{

DataTable dataTable = new DataTable("tvpTID");

dataTable.Columns.Add("TrainerID", typeof(Int32));

foreach (ListItem item in CheckBoxListTrainers.Items)

{

if (item.Selected)

{

DataSet1TableAdapters.tbl_Trainer1TableAdapter tt = new DataSet1TableAdapters.tbl_Trainer1TableAdapter();

DataSet1.tbl_Trainer1DataTable dt = tt.GetDataBy(item.Text);

int i = int.Parse(dt.Rows[0][0].ToString());

dataTable.Rows.Add(i);

}

}

DataSet1TableAdapters.tbl_WorkshopTrainerTableAdapter ta = new DataSet1TableAdapters.tbl_WorkshopTrainerTableAdapter();

ta.sp_InsertWorkshopTrainers(txtTitle.Text, txtTopic.Text, DateTime.Now, txtDuration.Text, DateTime.Now, DateTime.Now, dataTable);

Response.Write("Workshop added successfully");

BindData();

}

THis worked well for me. THanks everyone who tried helping me:)