How to save Gridview Rows into database in Transpose form.

Question

Dear Friends I have Gridview as shown below... Project Name Field1 Field2 Field3 Project01 10 20 15 Project02 25 5 3 Project03 15 18 25 My data base table has two coulmn and i want to store above input as shown below Column1 Column2 Project01 10 Project01 20 Project01 15 Project02 25 Project02 5 Project02 3 Project03 15 Project03 18 Project03 25 How can i write SQL Procedure and C# code? Any suggestion? Thanks in advance.

Manas Mohapatra · Answer

Step1 : Read all rows from gridview private void BindGrid(DataTable dt bool rotate) { //Declare a data table and store all grid rows to datatable DataTable dt = new DataTable(); dt.Columns.AddRange( new DataColumn[2] { new DataColumn( ProjectName ) new DataColumn( ColumnVal ) }); foreach (GridViewRow row in GridView1.Rows) { string project=row.Cells[0].Text; // First column value e.g Project1 Project2 string column1=row.Cells[1].Text; // Second column value string column2=row.Cells[2].Text; // Third column value string column3=row.Cells[3].Text; // Fourth column value dt.Rows.Add(project column1); dt.Rows.Add(project column2); dt.Rows.Add(project column3); } } http://www.aspsnippets.com/Articles/Rotate-ASPNet-GridView---Convert-GridView-Columns-to-Rows-and-Rows-to-Columns.aspx Step2 : Send the datatable to server read data and insert it. http://www.aspsnippets.com/Articles/Send-Pass-DataTable-as-parameter-to-Stored-Procedure-in-C-and-VBNet.aspx

Mahesh Devikar · Answer

Thanks to Manas Mohapatra for quick reply Basically i want to perform CRUD on itSo if possible can you update answer accordingly. See the field columns are dynamically added and it will varies for each transaction so need to update accordingly. What will be best CRUD strategy (coding practice) to deal with such type of dynamic grid.

Project Name	Field1	Field2	Field3
Project01	10	20	15
Project02	25	5	3
Project03	15	18	25

Column1	Column2
Project01	10
Project01	20
Project01	15
Project02	25
Project02	5
Project02	3
Project03	15
Project03	18
Project03	25