can samebody help me with this simple problem.
I have 2 datalist and 2 ADO control in my program. the first datalist is name DATABRANCH and second is DATAEMPLIST. ADO control name AdoEmployee for employee table and AdoBranch for table branch.
I want to filter the employee name by branch.
i set the ADO control to this...
DATABRANCH rowsource is ADOBRANCH and ListField is branch_nm
DATAEMPLIST rowsource is ADOEMPLIST
Can someone help me with this.....
Here is my code...
Dim branchQuery As String
Private Sub Form_Load()
branchQuery = "SELECT tblemployee.branch_nm, tblemployee.lname, tblemployee.fname, tblemployee.mname from tblemployee JOIN tblbranch ON tblemployee.Branch_id = tblbranch.branch_id where tblemployee.branch_nm = "
DataEmpList.ListField = "lname"
Private Sub DataBranch_Click()
On Error Resume Next
AdoEmployee.RecordSource = branchQuery & "'" & DataBranch.Text & "'"
By Psion in forum ASP.NET
Last Post: 12-05-2005, 05:56 PM
By silverfox_1188 in forum ASP.NET
Last Post: 05-11-2005, 09:34 PM
By jrothlander in forum ASP.NET
Last Post: 04-27-2005, 05:43 PM
By Tim Giese in forum VB Classic
Last Post: 07-31-2001, 12:31 PM
By Carlos Gonzalez in forum ASP.NET
Last Post: 02-15-2001, 04:54 PM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center