Title Use a bound DBGrid control
Keywords DBGrid, bound DBGrid
Categories Controls, Database
Place a DBGrid and Data control on the form. Set the DBGrid's DataSource property to the Data control. Set other properties such as AllowAddNew, AllowDelete, and AllowUpdate as desired.
Set the Data control's DatabaseName property to the database. This example sets the database name at runtime like this:
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\CoData.mdb"
End Sub
Set the Data control's RecordSource property to the SQL SELECT statement the control should use to pick the data to be displayed. In this example, the property is set to:
SELECT Name, Department, Manager
FROM Employees, Departments
WHERE Employees.Department = Departments.DepartmentName
The DBGrid control displays the data automatically.
if any one want to ask any qustion then ask me likehamza@yahoo.co.uk
Keywords DBGrid, bound DBGrid
Categories Controls, Database
Place a DBGrid and Data control on the form. Set the DBGrid's DataSource property to the Data control. Set other properties such as AllowAddNew, AllowDelete, and AllowUpdate as desired.
Set the Data control's DatabaseName property to the database. This example sets the database name at runtime like this:
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\CoData.mdb"
End Sub
Set the Data control's RecordSource property to the SQL SELECT statement the control should use to pick the data to be displayed. In this example, the property is set to:
SELECT Name, Department, Manager
FROM Employees, Departments
WHERE Employees.Department = Departments.DepartmentName
The DBGrid control displays the data automatically.
if any one want to ask any qustion then ask me likehamza@yahoo.co.uk
