Loading data to a table is very important to a program running with CRUDS feature. First, This feature is very helpful to a program that update and delete data from a database. Remember that deleting and updating features requires a unique key/data to specify what row of data to delete.
Second, loading data to a table gives the user list of data so that user can browse the data and select which data want to be updated or deleted. It gives also an interface design that can attract to end user.
In this tutorial, I inserted 1 elements from toolbox, the DatagridView. DatagridView is an element of Visual Studio used to display retrieved data from a Database both in C# and VB.Net.
Source Code
Second, loading data to a table gives the user list of data so that user can browse the data and select which data want to be updated or deleted. It gives also an interface design that can attract to end user.
In this tutorial, I inserted 1 elements from toolbox, the DatagridView. DatagridView is an element of Visual Studio used to display retrieved data from a Database both in C# and VB.Net.
Source Code
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Try | |
Str = "SELECT * FROM person" | |
conn.Open() | |
Dim Search As New MySqlDataAdapter(Str, conn) | |
Dim ds As DataSet = New DataSet | |
Search.Fill(ds, "person") | |
DataGridView1.DataSource = ds.Tables("person") | |
conn.Close() | |
Catch ex As Exception | |
MsgBox(ex.Message) | |
conn.Close() | |
End Try |
0 Comments