Loading

How to save Gridview Rows into database in Transpose form.

How to save Gridview Rows into database in Transpose form.

Mahesh Devikar

Mahesh Devikar

10y1.1kLearn iOS Programming

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Devikar10y ago
Thanks toManas Mohapatrafor quick reply,
Basically i want to perform CRUD on it,So 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.
0
Manas Mohapatra10y ago
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
+1