Fill() problem in VS .NET 2003 in Windows application C# with SQL Server

[Auto]

I starting to use Visual Studio .NET 2003 creating C# Windows application
with SQL Server and I get problem with method Fill() for which when
running ends with System Error even with the most simple cases which I
copied from a tutorial. everything else works right for ex Preview Data
except for example sqlDataAdapter1.Fill(ds1).

Is it a bug or some other kind of error. What should I do?

Dalius

Fill() problem in VS .NET 2003 in Windows application C# with SQL Server

 

[Nick Harris]

What is the error your getting?

 

[Auto]

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll

Additional information: System error.

 

[Cor]

Hi Auto,

Most likely you have not created your datadapter or dataset as new

Cor

 

[Auto]

I did!
And DataPreview work correctly... I see tables and data in source DB.

Only Fill() does not work
I tried with simplest program using build in Northwind DB - fill() does
fail() too.
I think it is a bug or I have reinstall VS.NET 2003 ?
Any suggestions.

 

[Miha Markic]

Hi Auto,

Try opening the connection before Fill and place the call between try/catch
block.
It will show us if the problem lies within connection...

 

[Cor]

Hi Auto,

I understand now that you did make it using the desinger,
are you sure that the name of the dataset is correct?

Cor