DataSet and View

[Krzysztof]

How can I fill DataSet witch data from view?
Sample:
daDictionary = new OleDbDataAdapter("select * from " + viewName,
myConnection);
daDictionary.Fill( myDataSet, viewName);

What must be done to do it?

Regards
Krzysztof

[Miha Markic]

Hi,

The same as filling from table.
Is there any error you are getting?

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

"Krzysztof" <kk******@poczta.onet.pl> wrote in message
news:bq**********@news.onet.pl...

How can I fill DataSet witch data from view?
Sample:
daDictionary = new OleDbDataAdapter("select * from " + viewName,
myConnection);
daDictionary.Fill( myDataSet, viewName);

What must be done to do it?

Regards
Krzysztof

[Selvin]

<ciach>

How can I fill DataSet witch data from view?
Sample:
daDictionary = new OleDbDataAdapter("select * from " + viewName,
myConnection);
daDictionary.Fill( myDataSet, viewName);

did you open myConnection before you using it?

pozdrawiam

Przemek Sulikowski
ps. i dlaczego nie zapytales wczesniej na alt.pl.comp.lang.charp

[Miha Markic]

Hi Selvin,

There is no need to open the connection before - Fill is smart enough to
open/close it if it is closed...

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

Developer Express newsgroups are for peer-to-peer support.
For direct support from Developer Express, write to su*****@devexpress.com
Bug reports should be directed to: su*****@devexpress.com
Due to newsgroup guidelines, DX-Squad will not answer anonymous postings.

"Selvin" <selvin_nospam@nospam_osadkowski.com.pl> wrote in message
news:bq**********@news.onet.pl...

did you open myConnection before you using it?