เรื่องการเลือกข้อมูลจาก Dropdownlist แล้วให้ข้อมูลไปแสดงที่ Gridview ตามที่เลือกครับ

   Private Sub Get_DetailREQ()
        Dim str As String
        Dim dt As New DataTable
        Dim status_ap As String
        str = "SELECT tb_request.req_id, "
        str += "tb_request.emp_id,tb_request.req_name,tb_request.req_section, "
        str += "tb_request.req_status,tb_center.appr_status,tb_center.subject,tb_center.job_desc, "
        str += "tb_center.job_type,tb_center.pic,tb_center.job_start,tb_center.job_end "
        str += "FROM tb_request LEFT JOIN tb_center ON tb_request.req_id = tb_center.req_id "
        str += "WHERE tb_center.job_type = '" & Me.ddlReqType.Text.ToString & "' "
        str += "ORDER BY tb_request.req_id DESC "
        dt = BKC.DS_OleDB(str, strEhelpdesk_OleDB).Tables(0)

        'If (dt.Rows(0).Item("appr_status") = 0) Then
        '    status_ap = "Approved"
        'Else
        '    status_ap = "None Approve"
        'End If
        grdJobCenter.DataSource = dt
        grdJobCenter.DataBind()
        ConvertDate(Me.grdJobCenter, 9)
        ConvertDate(Me.grdJobCenter, 12)
    End Sub

    Protected Sub ddlReqType_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles ddlReqType.SelectedIndexChanged
        Get_DetailREQ()
    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
        'Get_DetailREQ()
    End Sub