There is no row at position 1

[dvannoy]

getting an error saying "There is no row at position 1" using the below code to fill in a data grid. weird thing is, I only get the error every once in a while. can't pin point why the error is happening.

any help would be appreciated


Dim sql As String = "SELECT MyFields from MyTable where Field1 = '" & l8.Text & "' ORDER BY Field1"
Dim connection As New SqlConnection(strcn)
connection.Open()
sCommand = New SqlCommand(sql, connection)
sAdapter = New SqlDataAdapter(sCommand)
sBuilder = New SqlCommandBuilder(sAdapter)
sDs = New DataSet()
sAdapter.Fill(sDs, "Table")
sTable = sDs.Tables("Table")

dg1.DataSource = sDs.Tables("Table")

l14.Text = dg1.Rows.Count

 

[jebenson]

What line throws the error?

Do you have any error trapping code (i.e., Try...Catch)?

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!