during runtime some of the checkboxes in control array are set backcolor by the colordialog using the following code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim a As Integer For a = 1 To 15 If ColorDialog1.ShowDialog() Then checkarray(a).BackColor = ColorDialog1.Color If ColorDialog1.ShowDialog = DialogResult.Cancel Then Exit For End If End If Next End Sub
My question is i want to send the colors filled in the check boxes into the sql server table throug insertsql statement
my trial code is as follows but it is wrong
insertsql = "insert into colordetails(model,color)values('" & ComboBox1.Text & "','" & checkarray(a).BackColor & "')"
colordetails in tablename in sql server and model and color are field names in that table