Hi,

I have a GridView with several rows of data and I want this data to be inserted into a SQL Server Express table using VWD Express and VB.

The problem is that I don't know how to index the GridView. Here is what I have in my code behind page:

    Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim conn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings("ekodbConnectionString").C onnectionString)
        Dim row As Integer
        Dim cust_ID As Integer
        Dim firstname As String
        Dim lastname As String
        For row = 1 To 10
            cust_ID = GridView1[row,1].Item 'Needs to be corrected!
            firstname = GridView1[row,2].Item 'Needs to be corrected!
            lastname = GridView1[row,3].Item 'Needs to be corrected!
            Dim cmd As SqlCommand = New SqlCommand("INSERT INTO customers VALUES (" & cust_ID & ", " & firstname & ", " & lastname & ")", conn)
            conn.Open()
            cmd.ExecuteScalar()
            conn.Close()
        Next
    End Sub

1. So, instead of the errorenous lines of code for retrieving the GridView values, what should I write?

Two additional questions:
2. In the code above, I stated For row = 1 To 10. Can I write While row <> nil or something to get everything?

3. I use cmd.ExecuteScalar, which works but is not really making sense as I don't try to get a value from the sub. Is there anything else that works to get the Sql going?

Thanks very much in advance for help with any of this!

Pettrer,Sweden


Coding is indeed a nine-to-five job; nine pm to five am.

__________________
Coding is indeed a nine-to-five job; nine pm to five am.

Hi,

I got a reply in another forum (asp.net). I post it here and hope it's helpful to others.

Pettrer

============

Hi,

I think your problem is how to nagivate through the rows in your gridview.
You have to work out a few things:
1. Make sure you gave a ID for the bound controls in your aspx file say:
    lblCustID, lblFirstname, lblLastName - you will need these to refer to which label controls (asp:label) in the row you need to access.

2. You navigate the existing rows from top to bottom. If you need to access a certain record then you have to add another hidden column where you put a unique ID.

Here how it works:

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim conn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings("ekodbConnectionString").C onnectionString)




For Each gvr As GridViewRow In MyGridVie.Rows
      ' reference the labels in the row
      Dim cust_ID As String= CType(gvr.FindControl("lblCustID"), Label).Text
      Dim firstname As String=CType(gvr.FindControl("lblFirstName"), Label).Text
      Dim lastname As String=CType(gvr.FindControl("lblLastName"), Label).Text
         Dim cmd As SqlCommand = New SqlCommand("INSERT INTO customers VALUES (" & cust_ID & ", " & firstname & ", " & lastname & ")", conn)
            conn.Open()
            cmd.ExecuteNonQuery()
            conn.Close()
Next

end sub

Since you are only inserting and not expecting a return value, you should use "ExecuteNonQuery"

I hope this helps.

Cheers,

Wilmar, KSA (Mabuhay!)


Coding is indeed a nine-to-five job; nine pm to five am.