How to do as following?

Question

i need to display as Fig_1 database contents from table,when we click a button

Fig_1
	EmpName	DOB	Salary	Age
Edit	Adam	2811987	6122	25
Edit	Sam	2811987	4555	25
Edit	Sue	2811987	5555	24
Edit		2811987	7544	26
Edit		2811987	4455	23
Edit		2811987	4533	22
Edit		2811987	4655	22
Edit		2811987	2987	23

then I need to edit a particular Row when i click on Edit Link button that show form as Fig_2

EmpName	enter name here
DOB	enter DOB here
Salary	enter salary here
Age	enter age here

and save button in Fig_2

Thanks in advance......

Santhosh Kumar Jayaraman · Answer

Hi Get db table values in a datatable and call this method. public DataTable FlipDataTable(DataTable dt) { DataTable table = new DataTable(); for (int i = 0; i table.Columns.Add(Convert.ToString(i)); DataRow r; for (int k = 0; k { r = table.NewRow(); r[0] = dt.Columns[k].ToString(); for (int j = 1; j r[j] = dt.Rows[j - 1][k]; table.Rows.Add(r); } return table; }