How to bind two columns as single column in GridView

Question

Hi friends i have one problem please give me the solution for this one urgent

I hava two columns in database those are
validfrom, validto

validfrom validto
--------- -------
04/07/2011 05/08/2011
05/07/2011 06/08/2011

How can i display these two columns as single column using gridview like this

validperiod
-----------
04/07/2011 -05/08/2011
05/07/2011 - 06/08/2011

Please give the solution for this one please..........i need exactly code for this one.........

Manish Dwivedi · Answer

Hi bhanu try this - and in the .cs file just bind your grid.

Manish Tewatia · Answer

You can try this.... protected void GridView1_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[1].ColumnSpan = 3; e.Row.Cells[1].Text = Code; e.Row.Cells.RemoveAt(3); e.Row.Cells.RemoveAt(2); } else if (e.Row.RowType == DataControlRowType.DataRow) { string cell1 =  + ((Label)e.Row.FindControl(A2)).Text; string cell2 =  + ((Label)e.Row.FindControl(A3)).Text; e.Row.Cells[1].ColumnSpan = 3; e.Row.Cells[1].Text = ((Label)e.Row.FindControl(A1)).Text + cell1 + cell2; e.Row.Cells.RemoveAt(3); e.Row.Cells.RemoveAt(2); } }

bhanu prasannakumar · Answer

thank you very much boss...........

Suthish Nair · Answer

eg get an extra column from sql query: select (cast(validfrom as varchar) + '-' + cast(validto as varchar)) validperiod

bhanu prasannakumar · Answer

please give me the full code...please

Amit Choudhary · Answer

Hi Bhanu Do one this use a template field in grid and bind the field text like this: ' ..... /> Hope this helps you.