sql - How to save the header of the datagridview in database using vb.net

Question

We wanted to save the header of a datagridview in the database. The header of the datagridview is the value we inputted in the textbox .What we want is to save the header as the field of our database . Does anyone know how to do it ??thank you

Answer 1

Hmmm... Like This one ?

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
    Dim fetchDGVHeaders(DataGridView1.ColumnCount) As String
    For a = 0 To DataGridView1.ColumnCount - 1
        fetchDGVHeaders(a) = DataGridView1.Columns(a).Name
        MsgBox(fetchDGVHeaders(a))
    Next
    INSERT_INTO_DB("INSERT INTO DBHeaders(MEaw,MEow,MEow_MEow)VALUES('" & fetchDGVHeaders(0) & "','" & fetchDGVHeaders(1) & "','" & fetchDGVHeaders(2) & "','" & fetchDGVHeaders(3) & "')")
End Sub

Fetch the current DataGridView Headers then store it to other table