Data Grid

Question

How to use Data Grid View Control? pls send me with Example Thanks&Regs Magesh

Sam Hobbs · Answer

For best results using the DataGridView Control, you need to look in this site's home page for articles about it. Then, after reading some articles, when you need to request assistance in the C# Corner forums, you need to ask the questions in the Windows Forms forum or whatever UI you are using but not the C# Language forum.

Satyapriya Nayak · Answer

Hi Magesh, To display data in a datagridview from database. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Datagridview_bind { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from customer"; com = new OleDbCommand(str, con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds, "customer"); dataGridView1.DataMember = "customer"; dataGridView1.DataSource = ds; con.Close(); } } } Thanks

Senthilkumar · Answer

Hi Magesh, The MSDN have some description about the GridView usage with an example. http://msdn.microsoft.com/en-us/library/aa479342.aspx You can find more examples like GridView Binding, edit, update, Loading images, dropdown, etc..,in the following examples. http://www.dotnetspider.com/resources/Category518-ASP-NET-GridView.aspx http://www.c-sharpcorner.com/uploadfile/raj1979/gridview-examples-for-Asp-Net-2-0/ http://www.exforsys.com/tutorials/asp.net-2.0/asp.net-2.0-the-gridview-control.html

Data Grid

Answers (3)