Datagridview

Question

Please can somebody tell me how to show data in datagridview through dataadapter and dataset from data base... Please reply me quickly i need it. it's urgent Regards Zeb

Zeb Rehman · Answer

Thanks Mr. Nayak that really helped me a lot.....

Satyapriya Nayak · Answer

Hi Zeb If this post helps you mark it as answer Thanks

Satyapriya Nayak · Answer

Hi Zeb str = select custidcustname from customer; Here custid and custname will be displayed in the datagridview.If you use * all columns will be displayed in the datagridview. Thanks

Zeb Rehman · Answer

Thanks bro what if i want to show some attributes from a given table...

Satyapriya Nayak · Answer

Hi Zeb Try this... 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