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" <da****@autocentras.com> wrote in message
news:eY**************@TK2MSFTNGP09.phx.gbl...

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

[Auto]

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

Additional information: System error.

"Nick Harris" <nh*****@VizSoft.net> wrote in message
news:OZ**************@TK2MSFTNGP10.phx.gbl...

What is the error your getting?
"Auto" <da****@autocentras.com> wrote in message
news:eY**************@TK2MSFTNGP09.phx.gbl...

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

[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.

"Cor" <no*@non.com> wrote in message
news:OD**************@tk2msftngp13.phx.gbl...

Hi Auto,

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

Cor

[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...

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

"Auto" <da****@autocentras.com> wrote in message
news:eZ**************@tk2msftngp13.phx.gbl...

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.

"Cor" <no*@non.com> wrote in message
news:OD**************@tk2msftngp13.phx.gbl...

Hi Auto,

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

Cor

[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