sql checkedlistbox and insert statement
C#
1
Posts
1
Posters
0
Views
1
Watching
-
+ "')"; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(sql, myConnection); adapter.Fill(ds, "TechSkillSet"); DataTable dt = ds.Tables["TechSkillSet"]; foreach (DataRow row in dt.Rows) { foreach (DataColumn col in dt.Columns) sql = "Insert into TechSkillSet (EmployeeID,TechnicalSkillsID) values (" + techSkillsCheckListBox2.CheckedItems[x] + " , " + FirstnameText.Text.ToString() + " , " + Lastnametext.Text.ToString() + ")"; } {