How to Display selected Row from DataGridView to TextBox in C#
By FoxLearn 11/28/2024 2:45:49 PM 4.63K
In this article, we will explore how to use the DataGridView
control in C# to display data from a database table, and how to capture the selected row to display its content in a TextBox
.
Displaying Selected Row Data from DataGridView in a TextBox in C#
Open Visual Studio, then click New Project, then select Visual C# on the left, then Windows and then select Windows Forms Application. Name your project "DataGridViewTextBox" and then click OK
We will start with a simple Windows Forms application that uses a DataGridView
control to display data. The data will come from a database, which in this case is the Northwind database's Categories
table.
Drag and drop the DataGridView
and TextBox
controls onto the form. The TextBox
controls will display the data from the selected row of the DataGridView
.
Create a new dataset, then select category table from Northwind database
Add a BindingSource
to both the DataGridView
and TextBox
controls. After placing the DataGridView
on the form, set its DataSource
property to northwindDataSet.Categories
to automatically display the data loaded in the Form1_Load
method.
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace DataGridViewTextBox { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'northwindDataSet.Categories' table. You can move, or remove it, as needed. this.categoriesTableAdapter.Fill(this.northwindDataSet.Categories); } } }
We use the categoriesTableAdapter.Fill
method to load the Categories
table from the northwindDataSet
into the DataGridView
. The categoriesTableAdapter
queries the database and fills the dataset, which then automatically populates the DataGridView
.
VIDEO TUTORIAL
- How to Print Text in a Windows Form Application Using C#
- How to fill ComboBox and DataGridView automatically in C#
- How to Read text file and Sort list in C#
- How to pass ListView row data into another Form in C#
- How to read and write to text file in C#
- How to make a Countdown Timer in C#
- How to Get all Forms and Open Form with Form Name in C#
- How to Get Checked Items In a CheckedListBox in C#