Using db As New SqlConnection(my.settings.WSMplannet)
Try
db.Open()
Using cmd As New SqlCommand("usp_GetauditDetails",db)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@SiteInspectionID",Global.System.Data.SqlDbType.Int,4,Global.System.Data.ParameterDirection.Input,10,Nothing,Global.System.Data.DataRowVersion.Current,False,"",""))
cmd.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@NoAnswerMetaValue",""))
cmd.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@offset",""))
cmd.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@rows",""))

cmd.Parameters(0).Value = inspectionID
cmd.Parameters(1).Value = noAnswerMetaValue
cmd.Parameters(2).Value = offset
cmd.Parameters(3).Value = rows

Using dr As IDataReader = cmd.ExecuteReader
gvAuditDetails.DataSource = dr
gvAuditDetails.DataBind()

If dr.NextResult() And dr.Read() Then
    questionCount = dr.GetInt32(0)
Else
    questionCount = 0
End If


If dr.NextResult Then
    gvAuditQA.DataSource = dr
    gvAuditQA.DataBind()
End If
End Using
End Using

Catch ex As Exception
Throw ex
Finally
db.Close()
End Try
End Using

请参考上面给出的代码以获取更多说明。我遇到错误

  

使用datareader在位置0没有行。有被删除的列= 1

帮我处理这种类型的异常