Wednesday, 14 December 2016

Filling Data Grid View from Database

string slctcmd = string.Format("--Your SQL Query--");
            DataTable dt = qc.DataReaderTable(slctcmd);
            DataGridView.DataSource = dt;

            DataGridView.Columns[0].Width = 200;
            DataGridView.Columns[1].Width = 100;
            DataGridView.Columns[2].Width = 100;
            DataGridView.Columns[3].Width = 100;
            DataGridView.Columns[4].Width = 100;

No comments:

Post a Comment