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.