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.

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

"Gimen" <(E-Mail Removed)> wrote in message
news:075201c3da86$3016a890$(E-Mail Removed)...
> 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.

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?


>-----Original Message-----
>Hi Gimen,
>
>You won't be able to limit the columns that DataView
shows.
>Rather don't display them at UI level.
>
>--
>Miha Markic - RightHand .NET consulting & software
development
>miha at rthand com
>www.rthand.com
>
>"Gimen" <(E-Mail Removed)> wrote in message
>news:075201c3da86$3016a890$(E-Mail Removed)...
>> 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,

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

"Gimen" <(E-Mail Removed)> wrote in message
news:09e901c3da89$6deba3c0$(E-Mail Removed)...
> 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?
>
>
> >-----Original Message-----
> >Hi Gimen,
> >
> >You won't be able to limit the columns that DataView
> shows.
> >Rather don't display them at UI level.
> >
> >--
> >Miha Markic - RightHand .NET consulting & software
> development
> >miha at rthand com
> >www.rthand.com
> >
> >"Gimen" <(E-Mail Removed)> wrote in message
> >news:075201c3da86$3016a890$(E-Mail Removed)...
> >> 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.
> >
> >
> >.
> >

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
>
>"Gimen" <(E-Mail Removed)> wrote in message
>news:09e901c3da89$6deba3c0$(E-Mail Removed)...
>> 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?
>>
>>
>> >-----Original Message-----
>> >Hi Gimen,
>> >
>> >You won't be able to limit the columns that DataView
>> shows.
>> >Rather don't display them at UI level.
>> >
>> >--
>> >Miha Markic - RightHand .NET consulting & software
>> development
>> >miha at rthand com
>> >www.rthand.com
>> >
>> >"Gimen" <(E-Mail Removed)> wrote in message
>> >news:075201c3da86$3016a890$(E-Mail Removed)...
>> >> 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.
>> >
>> >
>> >.
>> >
>
>
>.
>

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

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

"Gimen" <(E-Mail Removed)> wrote in message
news:0cab01c3da9f$165d89f0$(E-Mail Removed)...
> 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
> >
> >"Gimen" <(E-Mail Removed)> wrote in message
> >news:09e901c3da89$6deba3c0$(E-Mail Removed)...
> >> 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?
> >>
> >>
> >> >-----Original Message-----
> >> >Hi Gimen,
> >> >
> >> >You won't be able to limit the columns that DataView
> >> shows.
> >> >Rather don't display them at UI level.
> >> >
> >> >--
> >> >Miha Markic - RightHand .NET consulting & software
> >> development
> >> >miha at rthand com
> >> >www.rthand.com
> >> >
> >> >"Gimen" <(E-Mail Removed)> wrote in message
> >> >news:075201c3da86$3016a890$(E-Mail Removed)...
> >> >> 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.
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >