searching using dropdownlist bind to gridview?

Reply

blink_1106 Posted: 10-18-2007 3:02 AM

rated by 0 users

Protected Sub ddlCardNum_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlCardNum.SelectedIndexChanged
        Dim constr As String = ConnString_Main
        Dim dbcon As New SqlConnection(constr)
        Dim cmd As SqlCommand = New SqlCommand
        Dim dr As SqlDataReader

        dbcon.Open()

        cmd = New SqlCommand()
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "sp_search_special_instructions"
        cmd.Connection = dbcon
        cmd.Parameters.Add("@card_num", SqlDbType.NVarChar).Value = ddlCardNum.SelectedValue

        dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)

        'binding select statement to the grid
        Dim param As New Collection
        Dim dView As New DataView(task.ExecProc_View("sp_search_special_instructions_by_cardnum", param))
        Me.gvSearchResults.DataSource = dView
        Me.gvSearchResults.DataBind()

        'close connection
        cmd.Dispose()
        dbcon.Close()
        
        If gvSearchResults.Rows.Count <= 0 Then Errorlbl.Text = "No record found."

    End Sub

kindly please correct mycode.thanks