Create DataTable From Existing DataTable

  • Thread starter Thread starter Gimen
  • Start date Start date
G

Gimen

i created a SataSet that contain several DataTables,
i need to create some more DataTables and DataVies,
the problem is that each of them should contain another
DataColumns, i eant to select the columns from the
existing tables not only the rows.
sample:
one of the datatables in the dataset contain those
DataColumns: firstName, lastName, address,phone,fax and
mobile,
i want to create DataView that carry all the rows that the
last name begin with 'A' , but the columns needed are only
the last name and first name.
 
Hi Gimen,

You won't be able to limit the columns that DataView shows.
Rather don't display them at UI level.
 
that what i did for now, but the source datatable is very
heavy and i want to save memory and trafic by sending only
the needed columns.
maybe working full connected is preferred in that
situation?
 
Hi Gimen,

If the traffic is the problem, why don't you select just the columns you are
interested in?
 
thats i'm trying to do,
-----Original Message-----
Hi Gimen,

If the traffic is the problem, why don't you select just the columns you are
interested in?

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com




.
Click to expand...
 
Hmmm..
Instead of "SELECT * FROM Table" you should use "SELECT Column1, Column2
FROM Table".
Isn't this a solution?
 
Back
Top