.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

How to get the Values of Slected Cell Row DataGridview(Windows Appliction) using C# ?

Posted By:Syed Shakeer Hussain       Posted Date: May 23, 2009    Points: 25    Category: DataBase    URL: http://www.dotnetspark.com  
 

Open Window Form.Add on DataGridview and three Textboxes on windows Form.
In the above example I am created on emp table and having 3 columns as id number,empname(varchar (20),salary number(20).


In form load Retrive the data a emp Table and fill in the Datagridview.When you click or Select a Row on DataGridview the particular selected row values will display in Textboxes by using below code.


int i;
i = dataGridView1.SelectedCells[0].RowIndex;
textBox1.Text = dataGridView1.Rows[i].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[i].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[i].Cells[2].Value.ToString();



before using this code you have to double click your DataGridview and write the code in
between the

Private void dataGridView1_CellContentClick_(objectsender,DataGridViewCellEventArgs e)
{

//write above code here...

}

when you selecte a row in datagrid ,the seletedc row Values will display in textboxes .below is the output image:

below is the complete code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlDataAdapter da;
DataSet ds;
int i;
SqlConnection conn;
private void Form1_Load(object sender, EventArgs e)
{
conn = new SqlConnection("connetion tring");
conn.Open();
da= new SqlDataAdapter("select * from emp", conn);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "emp");
dataGridView1.DataSource = ds.Tables["emp"];
}

Private void dataGridView1_CellContentClick_1(objectsender,DataGridViewCellEventArgs e)
{
i = dataGridView1.SelectedCells[0].RowIndex;
textBox1.Text = dataGridView1.Rows[i].Cells[0].Value.ToString();
textBox2.Text = dataGridView1.Rows[i].Cells[1].Value.ToString();
textBox3.Text = dataGridView1.Rows[i].Cells[2].Value.ToString();
}
}

 

 Subscribe to Articles

     

Further Readings:

Responses
Author: c2         Company URL: http://www.dotnetspark.com
Posted Date: June 14, 2010

can i d it reverse i.e. from textbox to datagrid view current cell/selected cell

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend