I added this code to the code behind but when there are not records nothing appears:
If GridView1.EmptyDataText = ""
Then
Response.Write(
"No Pending Records"
)
End
If
If Pending.SelectedValue = "400" Then
Dim conn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("PendingClaimsConnectionString").ConnectionString)
Dim cmd As New Data.SqlClient.SqlCommand
Dim cmdPending As New Data.SqlClient.SqlCommand
With cmdPending
.CommandType = Data.CommandType.StoredProcedure
.CommandText = "GetDDS400" .Connection = conn
.Parameters.AddWithValue("@doc", Request.QueryString("doc"))
End With
Dim adapter As New Data.SqlClient.SqlDataAdapter(cmdPending)
Try conn.Open()
Dim ds As New Data.DataSet adapter.Fill(ds)
GridView1.DataSourceID = ""
If GridView1.EmptyDataText = "" Then
Response.Write("No Pending Records") End If
GridView1.DataSource = ds GridView1.DataBind()
Finally conn.Dispose() End Try
End If End Sub