how to add table in windows form

Question

hello everyone, i want to add table in windows form .. i want to display data from database in table .. i don't want to use datagridview . help me how to ??

Manoj Bhoir · Answer

Hi, Why you don't want to use DataGridView. It provides so many properties and methods through which you can easily display your data from database to your windows form. Is there any specific reason? If not i will suggest you to use DataGridView Control. You can display data on your form using ListView Control in table format. -Set ListView View to Details . -Add Columns in your ListView. -Set GridLines to true . Try this code : SqlConnection con = new SqlConnection("connectionstring"); SqlDataAdapter ada = new SqlDataAdapter("select * from TableName", con); DataTable dt = new DataTable(); ada.Fill(dt); for (int i = 0; i { DataRow dr = dt.Rows[i]; ListViewItem listitem = new ListViewItem(dr["Column1"].ToString()); listitem.SubItems.Add(dr["Column2"].ToString()); listitem.SubItems.Add(dr["Column3"].ToString()); listitem.SubItems.Add(dr["Column4"].ToString()); listView1.Items.Add(listitem); }

Manoj Bhoir · Answer

Welcome :)

Jiyalal Gupta · Answer

Thank you thank you thank you sir

Manoj Bhoir · Answer

Hi, I think yes you can hide first Selection row of your datagridview. Here is a solution for standard windows controls in C#. To hide the row headers you can use the property RowHeadersVisible and set it to false. To make the row headers smaller you can use the property RowHeadersWidth .

Jiyalal Gupta · Answer

yes. thre is big reson actchuly my app is for printing invoice from database if i'll use datagridview the datagridview print 1st column also which is not useful for me.. is thre any idea to hide 1st default column of datadridview?? note - my mean for 1st column is the column which we select for perfoming selection row.

how to add table in windows form

Answers (5)