loading data in datagrid using class

Carlos kambui

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka11y ago
Accepted 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 kambui11y ago
show data on datagrid
Sanjeeb Lenka11y ago
check this link

http://www.aspsnippets.com/Articles/Display-contents-of-DataTable-in-DataGridView-in-Windows-Forms-Application-using-C-and-VBNet.aspx
Dipankar Biswas11y ago
HI
See this link...http://www.c-sharpcorner.com/UploadFile/scottlysle/BindObjects02112007233926PM/BindObjects.aspx

Thanks
Sabyasachi Mishra11y ago
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"