GRIDVIEW

[GauravKP]

I stored FirstName and LastName in two column in table... I want to show them in a single column in gridview along with their email and other details. Any suggestion ......

[Ravi Mori]

You just need to bind both columns FirstName and LastName on a single gridview column using string concatenation

[Parwej Ahamad]

Use template column

Parwej Ahamad ahamad.parwej@gmail.com

[Suresh Suthar]

In you Select statement just do this..

Select FirstName + ' ' + LastName as [Name] from table

Be an Eagle, Sky is Yours.

[Vimalsoft Pty Ltd]

DO this from the SQL Side and let the grid display what is comming from SQL. Dont do your manipulation in the Grid.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[GauravKP]

U r one of that clerks thanx

[Vimalsoft Pty Ltd]

You are Welcome :)

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[sohighthesky]

you can write your sql like this: select FullName=FisrtName+LastName from your_tableName if your are using Access Database ,then it should be change: select FisrtName+LastName from your_tableName

[Dhruv SoluSoft]

There are 2 sollutions : - You can use ItemTemplate with TemplateColumn. It will be useful if you want to format the contents, and you need specific control for specific content. - Going on SQL side, you can adjust the query itself to produce the firstname+lastname's combination, if you just want to display the information.