How to Get DataRow Based on DataGridView in C#

Submitted by janobe on Thursday, May 30, 2019 - 22:34.

In this tutorial, I will teach you how to get DataRow Based on DataGridView using C#. This method can easily get the data in a selected row in the datagridview. It also extracted the data and display it in a certain textbox when you click the cells in a row inside the datagridview. I used Microsoft Visual Studio 2015 and XAMPP to develop this application.

Creating Database

Create a database named “db_user”. Write the following query to create a table and add the data in the table.

CREATE TABLE `tbl_user` (
  `UserID` int(11) NOT NULL,
  `Fullname` varchar(30) NOT NULL,
  `Username` varchar(90) NOT NULL,
  `Pass` varchar(90) NOT NULL,
  `UserType` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `tbl_user`
--
 
INSERT INTO `tbl_user` (`UserID`, `Fullname`, `Username`, `Pass`, `UserType`) VALUES
(1, 'Janno Palacios', 'janobe', 'admin', 'Administrator'),
(2, 'Jeanniebe Nillos', 'jean', 'janobe', 'Staff');
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `tbl_user`
--
ALTER TABLE `tbl_user`
  ADD PRIMARY KEY (`UserID`);

Creating Application

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application for c#. ps1

Step 2

Do the form just like shown below. ps2

Step 3

Press F7 to open the code editor. In the code editor, add a namespace to access MySQL libraries

 
using MySql.Data.MySqlClient;

Step 4

Establish a connection between C# and MySQL database. After that, declare all the classes and variables that are needed.

  
        MySqlConnection con = new MySqlConnection("server=localhost;user id=root;password=;database=db_user;sslMode=none");
        MySqlCommand cmd;
        MySqlDataAdapter da;
        DataTable dt;
        string sql;
        int maxrow;

Step 5

Create a method for retrieving data in the database.

 
        private void load_Data(string sql)
        {
            try
            {
                con.Open();
                cmd = new MySqlCommand();
                da = new MySqlDataAdapter();
                dt = new DataTable();
 
                cmd.Connection = con;
                cmd.CommandText = sql;
 
                da.SelectCommand = cmd;
                da.Fill(dt); 
                dataGridView1.DataSource = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
                da.Dispose();
            }
        }

Step 6

Create a method to extract the data and send it into the textboxes.

 
        private void retrieve_Data(string sql)
        {
            try
            {
                con.Open();
                cmd = new MySqlCommand();
                da = new MySqlDataAdapter();
                dt = new DataTable();
 
                cmd.Connection = con;
                cmd.CommandText = sql;
 
                da.SelectCommand = cmd;
                da.Fill(dt);
 
                maxrow = dt.Rows.Count;
                if (maxrow > 0)
                {
                    txtID.Text = dt.Rows[0].Field<int>(0).ToString();
                    txtName.Text = dt.Rows[0].Field<string>(1);
                    txtUsername.Text = dt.Rows[0].Field<string>(2);
                    txtPassword.Text = dt.Rows[0].Field<string>(3);
                    txtRole.Text = dt.Rows[0].Field<string>(4);
                }
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
                da.Dispose();
            }
        }

Step 7

Write the following code for retrieving data in the first load of the form

 
        private void Form1_Load(object sender, EventArgs e)
        {
            sql = "Select * From tbl_user ";
            load_Data(sql);
        }  

Step 8

Write the following code for sending data in the textboxes when the row of the datagridview is clicked.

 
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            sql = "Select * From tbl_user Where UserID = " + dataGridView1.CurrentRow.Cells[0].Value;
            retrieve_Data(sql);
        }

The complete source code is included you can download it and run it on your computer. For any questions about this article. You can contact me @ Email – [email protected] Mobile No. – 09305235027 – TNT Or feel free to comment below.

Add new comment

490 views