loading data in datagrid using class

Question

i have created class and class members for database using c# now i want to load data on database to datagrid on form load how can i go about it

Sanjeeb Lenka · Answer

public partial class Form1 : Form { public Form1() { InitializeComponent(); BindGrid(); } private void BindGrid() { string constring = @"Data Source=.\SQL2005;Initial Catalog=Northwind;User id = sa;password=pass@123" ; using ( SqlConnection con = new SqlConnection (constring)) { using ( SqlCommand cmd = new SqlCommand ( "SELECT * FROM Customers" , con)) { cmd.CommandType = CommandType .Text; using ( SqlDataAdapter sda = new SqlDataAdapter (cmd)) { using ( DataTable dt = new DataTable ()) { sda.Fill(dt); dataGridView1.DataSource = dt; } } } } } }

Carlos kambui · Answer

show data on datagrid

Sanjeeb Lenka · Answer

check this link http://www.aspsnippets.com/Articles/Display-contents-of-DataTable-in-DataGridView-in-Windows-Forms-Application-using-C-and-VBNet.aspx

Dipankar Biswas · Answer

HI See this link... http://www.c-sharpcorner.com/UploadFile/scottlysle/BindObjects02112007233926PM/BindObjects.aspx Thanks

Sabyasachi Mishra · Answer

I didn't get your question.You want to show data in datagrid or insert data in data base.As you have written " load data on database to datagrid "

loading data in datagrid using class

Answers (5)