How to insert multiple rows of datagridview in Windows form

Question

How to insert multiple rows of datagridview in Windows form application

Vasanth Natarajan · Answer

Hi Zeeshan Ahmed hope this will help you just get the data from backend and lode your ADO.net objects(DataSetDataTable) and bind the DataSet to DataGrid example for using (con = new SqlCeConnection(Properties.Settings.Default.DataConnectionString)) { con.Open(); // open the DB Connection using (SqlCeDataAdapter cmd = new SqlCeDataAdapter(SELECT * FROM Animals c)) //Cerate the dataAdopter { DataTable dt = new DataTable(); cmd.Fill(dt); dataGridView.DataSource = dt; } }

Karthik Elumalai · Answer

Hi Zeeshan Ahmed Hope the below linkwill helpful for you http://www.dotnetperls.com/datagridview-tutorial they have explained very clearly each and everything with snapshot. Kindly let me know if it was not clear or any questions. thanks karthik