part 1 : create & connect database to your program without coding.avi [ Ссылка ]

part 2 : insert data to database
[ Ссылка ]

part 3 : how to get data.avi
[ Ссылка ]

part 4 : how to edit data
[ Ссылка ]

part 5 : how to search data from database (TextBox)
[ Ссылка ]

Code for FormLoad :

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DatabaseName.mdb"
Combo1.Clear
Adodc1.RecordSource = "select distinct ColumnName from TableName"
Adodc1.Refresh
With Adodc1.Recordset
Do Until .EOF
Combo1.AddItem ![ColumnName]
.MoveNext
Loop
End With
Adodc1.RecordSource = "TableName"
Adodc1.Refresh

Code for Combo1_Click() :

Adodc1.RecordSource = "select * from TableName where ColumnName='" & Combo1 & "'"
Adodc1.Refresh

thanx for watching.. =)

свернуть