FirstName + ' ' + LastName as FullName, userId, .... Thanks one again
-----Original Message-----
Hahah...
dt was the DataTable you had all your data in....since you didn't provide
any inital code, I took a guess that you were using datasets or
datatables....if it's a dataset, it would simply be
dim dt as DataTable = ds.tables(0) or whatever table you wanted..
if you were using DataReader, i'd do it in the select statement select
FirstName + ' ' + LastName as FullName, userId, ....
Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
Either a DataTable or Delirium Tremens.
Red said:
Hello Karl,
How to add or where to add that code. another thing is
what is dt?
Thanks
-----Original Message-----
you could add a new computed column to your
dataset/datagrid:
dt.Columns.Add(new DataColumn("Denormalized",
System.Type.GetType("System.String"), "[FirstName]
[LastName]"));
Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the
popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial
newsgroup FAQ (more to
come!)
message
Hi all,
I would like to ask how to combine 2 field into one
column.
For example I have field first name and last name.
When I
show it to the datagrid I want to show it as one
column,
for example first name: Jack, lastname: sun become Jack
sun.
Thanks
.
.