How to use Rows and cells in Data Grid at WPF

Question

Hello friends I m stuck up on data grid . i have excel file which i had import into datagrid. Now what i want to do based on datagrid rows and cell values should be insert into database. Please tell me how would i save the excel file data into database using datagrid.

Naeem Khan · Answer

Hello nilesh I dont want that dear. i want in this format dataGridView1.Rows[i].Cells[ColumnName].Value how would i do it WPF datagrid

Nilesh Sawardekar · Answer

Try this public CustomerDataProvider() { NorthwindDataSet dataset = new NorthwindDataSet(); adapter = new CustomersTableAdapter(); adapter.Fill(dataset.Customers); dataset.Customers.CustomersRowChanged += new NorthwindDataSet.CustomersRowChangeEventHandler(CustomersRowModified); dataset.Customers.CustomersRowDeleted += new NorthwindDataSet.CustomersRowChangeEventHandler(CustomersRowModified); } void CustomersRowModified(object sender NorthwindDataSet.CustomersRowChangeEvent e) { adapter.Update(dataset.Customers); }

Naeem Khan · Answer

Hello Nilesh I am using WPF . In WPF there is not control of datagridview. there is only datagrid. and i m not the able to see rows and cell properties in datagrid . please find the some solution for it..so that i can save the rows and cell wise..

Nilesh Sawardekar · Answer

If you want to save row wise then see belowstring StrQuery; try {using (SqlConnection conn = new SqlConnection(ConnString)){using (SqlCommand comm = new SqlCommand()){comm.Connection = conn;conn.Open();for(int i=0; i< dataGridView1.Rows.Count;i++){StrQuery= @INSERT INTO tableName VALUES ( + dataGridView1.Rows[i].Cells[ColumnName].Value +  + dataGridView1.Rows[i].Cells[ColumnName].Value +);;comm.CommandText = StrQuery;comm.ExecuteNonQuery();}}} }