Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Make data grid display SQL
Name: RugZ Date: August 2, 2004 at 08:34:33 Pacific OS: Win2k CPU/Ram: 1.7/256
Comment:
I would like to use an SQL select statement that is Opened by Recordset Object of the DAO family and Display the results on a DataGrid.....How do i do this The code am using is as follows
Dim dbSales as Database Dim rsSalesDetails as Recordset
set dbSales=OpenDatabase("C:\Sales\Sales.mdb") strSQL="SELECT * FROM SalesDetails" set rsSalesDetails=dbSales.OpenRecordset(strSQL)
But how to make the recordset display on my DataGrid is the problem. Help!
Summary: i am writing an inventory program using VB6 and access database.My problem is that i want to use the data grid and the adodc to show the records of a particular table.When i set the record source and ...
Summary: Hi!, I want to know how I can create a Data Warehouse in SQL Server 2000, I have a DB Model and I want to know if I can create it from this model or I make a separate DB. Thanks a lot!! ...
