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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL