Hi I have grid view when click Search gridview will display and also click from dropdownlist it should display. Have a link in gridview if click link the values should pass to another page in textboxes so that I can update again. My issue is I cannot search when click search button and not from dropdown also. please suggest me to fix this issue. Below is the code in vb.net
Private Sub BindGridView()
Try
Dim filter As String = ""
If ddlOwnerDepartment.SelectedValue <> "" Then
filter = filter & " AND OwnerDepartment ='" & ddlOwnerDepartment.SelectedValue & "'"
Else
Dim table1 As DataTable = New DataTable("Details")
table1.Columns.Add("Title")
table1.Columns.Add("link")
table1.Columns.Add("ReferenceNo")
table1.Columns.Add("Counterparty Name")
table1.Columns.Add("OwnerDepartment")
table1.Columns.Add("Status")
table1.Columns.Add("CreatedBy")
table1.Columns.Add("CreatedOn")
table1.Rows.Clear()
Dim conSQL As New SqlConnection(conStrDRS)
conSQL.Open()
Dim cmdSQL As SqlCommand = New SqlCommand("SELECT Title, ReferenceNo ,Counterparty,Company,Custodian,OwnerDepartment,Status,Remarks,SecurityLevel, SelectedUsersAccess,CDMS_Doc_No, DocSourceDB,DocName" & _
" FROM [dbo].[Registration] " & filter)
cmdSQL.Connection = conSQL
Dim adptSQL As New SqlClient.SqlDataAdapter(cmdSQL)
Dim myDataSet As New DataSet()
adptSQL.Fill(myDataSet)
conSQL.Close()
With myDataSet.Tables(0)
For rowNumber As Integer = 0 To .Rows.Count - 1
With .Rows(rowNumber)
Dim docName As String = getDocName(.Item(0).ToString, .Item(9).ToString)
Dim link As String = ""
If checkEditDelete(.Item(8).ToString) Then
link = "~/edit.aspx?userID=" & Encrypt(hUserID.Value)
End If
table1.Rows.Add(.Item(1).ToString, .Item(2).ToString, getUserName(.Item(3).ToString, "name"), .Item(4).ToString, getStatusDesc(.Item(5).ToString), link, .Item(8).ToString)
End With
Next
If .Rows.Count = 0 Then
table1.Rows.Add("", "", "", "", "", "", "", "", "", "")
End If
End With
Dim set1 As DataSet = New DataSet("Alert")
set1.Tables.Add(table1)
Dim dvAlert As DataView = table1.DefaultView
dvAlert.Sort = ViewState("SortExpression").ToString()
gvDetails.DataSource = table1
gvDetails.DataBind()
Catch ex As Exception
End Try
End Sub