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