Hi.
Thanks for the advice.
I've tried it. Whether I leave the second part of the .fill blank, or put in
"table1", it still
gives me the error System.Data.SqlClient.SqlException: Invalid object name
'users'.
CJ
> Hi,
>
[quoted text clipped - 52 lines]
> >
> > Any Ideas? Any Questions?
kashifahmed.bse.mg@gmail.com - 31 Jan 2006 12:14 GMT
hi,
u may assign a name to dataset at creating time..
dim ds as dataset=new dataset("user1")
and please use try catch exception with finally....
u may better just declare variable first, then use try catch exception
and open connection
allocate memory for adapter then dataset and do further ur business
programming...
this all may help u to solve prob....
kashif ahmed
Camper Joe - 31 Jan 2006 13:23 GMT
Thanks for the support.
After reading up on datasets, I saw that if your SELECT query doesn't return
any rows, the table object doesn't get created.
CJ.
> hi,
>
[quoted text clipped - 13 lines]
>
> kashif ahmed
serge calderara - 31 Jan 2006 12:21 GMT
if mySqlAdapter.Fill(ds1) generate the error then try to verify your SQl
query within SQL querry to check if it works.
If it is, the from your code juste for test run the query "SELECT * FROM
user" just to check
If it works, verify your SQL string when it is build
regards
serge
> Hi.
>
[quoted text clipped - 62 lines]
> > >
> > > Any Ideas? Any Questions?
Camper Joe - 31 Jan 2006 13:27 GMT
Thanks for the support.
After reading up on datasets, I saw that if your SELECT query doesn't return
any rows, the table object doesn't get created.
CJ.
> if mySqlAdapter.Fill(ds1) generate the error then try to verify your SQl
> query within SQL querry to check if it works.
[quoted text clipped - 73 lines]
> > > >
> > > > Any Ideas? Any Questions?