In ADO.net there are plenty of class which make connecting database smooth as silk. Lets do it
Public Company As OleDb.OleDbConnection
Interacting with table
As far as we got everything is right and need to add, retrieve,update and delete rows to the table in the data base. The CURD operation can be made possible with a command object.
OleDbData Adapter – DataSet, DataView.
Dim dataset As DataSet = New DataSet()
DataGridView1.DataSource = dataset
DataGridView1.DataMember = “product_Registration“
The dataset can be used to fill DataGrid view too.
DataView object as the name indicate provides the table view. It can be useful when interact with the table rows.
Dim dv As DataView
dv = New DataView(dataset.Tables(“product_Registration”))
Dim c As Integer
c = 0
Do While c < dv.Count
c = c + 1
How to add all column names into a listview Column header in VB.Net, here is my complete tutorial for you
This tutorial will let you learn treeView coding in VB.net
Sharpen your coding skills with developer Central
Let me show how to add a new field into an existing access database using Visual Basic 6.0.Using the tableDef and Filed object you can create new fields. Firstly, you need to create Database and Recordset object, mke sure the DAO access object library. Continue reading Add new fields to Access table using VB6
How to add a auto complete feature in Microsoft Visual Basic 6 ?
With the help of some creepy code, we can save the entry into a data file temporarily and later we can use them as input for auto complete the name/place/text.
The code is work with Text box as well as Combo box. Drop the following code to a module call the methods defined. Continue reading How to auto complete text box in VB6
Here is how you can input and retrieve data into and from Microsoft Flex gridcontol in Visual Basic 6, just drag and drop and text box and flex grid. and do these code Continue reading Access and input data from MSFlexgrid control in VB6
How to delete selected items from a data table (Access) in Visual basic 6.0 ? Users can select the item using a list view control.
Get the count of selected items first Continue reading Delete selected (treeview) rows from data table in Visual basic 6.0