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

  • Thread starter Thread starter Auto
  • Start date Start date
A

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
 
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll

Additional information: System error.
 
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.
 
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...
 
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
 
Back
Top