Bind DatagridView from database?

Question

Please See the Attachment.

Dear all members,

I want to Bind DatagridView from database just like my Attachment designed

in Windows Application. C#.

How???? (not manual).

Please Help.

i am using that code.

private void binddata()
{
SqlDataAdapter da = new SqlDataAdapter(@"SELECT distinct Sectiontype + ' ' + '['+ Questiontype + ']' + ' ' + 'Attempt Question :-' + ' ' + Attemptquestion + ' ' + 'Total Marks :-' + ' ' + Totalmarks
as 'Groupst', Question,Fullmarks FROM dbo.tbl_QuestionConfig where Subject='C++'
group by Sectiontype + ' ' + '['+ Questiontype + ']' + ' ' + 'Attempt Question :-' + ' ' +
Attemptquestion + ' ' + 'Total Marks :-' + ' ' + Totalmarks ,Question,Fullmarks", con);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
dataGridView1.DataSource = dt;
dataGridView1.AutoGenerateColumns = false;
dataGridView1.AllowUserToAddRows = false;

dataGridView1.EnableHeadersVisualStyles = false;
dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.LightSeaGreen;
foreach (DataGridViewRow r in dataGridView1.Rows)
{
r.DefaultCellStyle.BackColor = Color.LightCyan;
}

}

Ajay Malik · Answer

try this code string select= SELECT*FROMtblEmployee ; Connectionc= new Connection(); SqlDataAdapterdataAdapter= new SqlDataAdapter(selectc.con); //c.conistheconnectionstring SqlCommandBuildercommandBuilder= new SqlCommandBuilder(dataAdapter); DataSetds= new DataSet(); dataAdapter.Fill(ds); dataGridView1.ReadOnly= true ; dataGridView.DataSource=ds.tables[0];

Bikesh Srivastava · Answer

Hi You are doing good but i think some little bit mistake .use debug in your code and run again. so please apply this.. using (SqlDataAdaptersda= new SqlDataAdapter(cmd)) { using (DataTabledt= new DataTable()) { sda.Fill(dt); dataGridView1.DataSource=dt; } }

Vinay Singh · Answer

Hi the the below link http://www.aspdotnet-pools.com/2014/07/how-to-bind-xml-to-datagridview-using-net-in-windows-application.html

Midhun T P · Answer

Hi Please check below link for details of Data Repeater control - https://blogs.msdn.microsoft.com/vsdata/2009/08/12/datarepeater-control-for-windows-forms/

Nirmal Roy · Answer

can we use any Repeater control in windows application C#? if yes then please send me code. step by step .

Nirmal Roy · Answer

Dear all members. please see my link - https://postimg.org/image/55zvylwpn/ i want windows application C#. not Web application. and see my Attachment..

Manas Mohapatra · Answer

Please find below : http://www.aspsnippets.com/Articles/Bind-Fill-DataGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx http://www.c-sharpcorner.com/uploadfile/deveshomar/ways-to-bind-datagridview-in-window-forms-c-sharp/ http://www.dotnetfunda.com/forums/show/6337/how-to-bind-datagridview-in-windows-application-using-csharpnet

Nirmal Roy · Answer

Dear Rajeesh Menoth i want windows application C#. not Web application. and see my Attachment..

Rajeesh Menoth · Answer

Hi Bind your grid properly. In your code just add the following line and bind the grid in page load. dataGridView1.DataSource = dt; dataGridView1..DataBind(); // add this line Reference : http://www.aspdotnet-suresh.com/2015/04/bind-data-in-gridview-in-aspnet-using-dataset-datatable-in-csharp-vbnet.html