How to bind my Datset to the Data Grid View Control?

Question

Hi, I have created a Dataset using the wizard that has a table "Employee"... How do i bind this dataset to the DataGridView control to display records on Form_Load()? TY

jinge · Answer

In case others have the same problem, I post the code here. public partial class Form1 : Form { DataSet1.EmployeeDataTable employeeDt = new DataSet1.EmployeeDataTable(); public Form1() { InitializeComponent(); this.Load += new EventHandler(Form1_Load); } void Form1_Load(object sender, EventArgs e) { try { EmployeeTableAdapter adapter = new EmployeeTableAdapter(); adapter.Fill(employeeDt); this.dataGridView1.DataSource = employeeDt; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } } Please do not forget to accept it as asnwer if it helps you solve the problem.

jinge · Answer

Yes, please send it to me.

petre ricardo · Answer

hi Jinge, I still cannot solve the problem...however i;ve sent you an email asking to receive an attachment .....: ) TY

jinge · Answer

Sorry, it should be DataMember. DataGridView dgv = new DataGridView(); dgv.DataSource = dataset; dgv.DataMember = "Employee";

petre ricardo · Answer

The Intelisense doesnt display my DataSet object DataSet1 and DataGridView controller doesnt display the property name DisplayMember, why? PS: I have created the dataset (dataset1.xsd) using the wizard

jinge · Answer

DataGridView1.DataSource = dataset1; DataGridView.DisplayMember ="Employee" Add these two lines will be OK>

How to bind my Datset to the Data Grid View Control?

Answers (6)