Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about how to implement the master / slave data table in VB.NET Data Grid. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

Before giving you a detailed introduction to VB.NET DataGrid, let you first understand the implementation of DataGrid2 content dynamic update, and then a comprehensive introduction to VB.NET DataGrid.

VB.NET Data Grid implements Master / Slave data Table

A more efficient solution is to use two VB.NET Data Grid controls where both the master and slave tables are visible. Selecting a row on the master table immediately causes a change in the contents of the slave table.

Set up the project, add a Panel control, set its Dock property to Top; to add a Splitter control, and set the Dock property to Top; to add a Panel,Dock property to top at the bottom of the form. Then, add a VB.NET Data Grid to each panel, whose Dock property is Fill.

In order to update the content of DataGrid2 dynamically, it is necessary to listen to the CurrentCellChanged event of DataGrid1 and load the corresponding data after receiving the change message of DataGrid1.

Imports System.Data.SqlClient

Public Class Form1

Const Connection String As String = "integrated security=sspi;initial catalog=pubs

Data source= (local) "

Private Sub Button1_Click (By Val sender As Object

By Val e As System.EventArgs) Handles Button1.Click

Dim cn As New SqlConnection (Connection String)

Cn.Open ()

Dim ds As New Dataset

Dim GetTitlesString As String = "Select * From Titles"

Dim Titles Table As New Data Table ("Titles")

Ds.Tables.Add (Titles Table)

Dim da As New SqlDataAdapter (GetTitlesString, cn)

Da.Fill (Titles Table)

Da.Dispose ()

Cn.Close ()

DataGrid1.DataSource = Titles Table

'The main table is displayed in DataGrid1

End Sub

Private Sub DataGrid1_CurrentCellChanged (By Val sender As Object

By Val e As System.EventArgs) Handles DataGrid1.CurrentCellChanged

Dim titled As String = DataGrid1.Item (DataGrid1.CurrentCell.RowNumber, 0). To String

'determine which row the user has selected in the main table and take out its 0th column (in this case, the title_ id column)

Dim sql As String = "select * from sales where title_id='" & titled & "'"

'SQL command string to select slave table data with the same title_ id value as in the master table

Dim cn As New SqlConnection (Connection String)

Cn.Open ()

Dim ds As New Dataset

Dim da As New SqlDataAdapter (sql, cn)

Dim Sales Table As New Data Table ("Sales")

Ds.Tables.Add (Sales Table)

Da.Fill (Sales Table)

'populate with selected slave table data, update

Da.Dispose ()

Cn.Close ()

DataGrid2.DataSource = Sales Table

End Sub

End Class

Run the program, select a row in the main table, and the slave table will display matching sales information.

By using the master / slave data table mode, good display and operation results can be achieved with less programming workload. If you want to establish a master / slave view associated with multiple tables, or to add, delete, modify, and so on, you can improve this method.

The above is the editor for you to share the VB.NET Data Grid how to achieve the master / slave data table, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.