I have a two column table (identity and ntext) setup to be used by
spro0c and vb.net. I can not get this select sproc to work from vb.net
but I can exec the sproc by itself? So it must be my sproc params?
I was selecting ntext through sproc and vb.net I have tried several

Every morning a .NET application downloads a file with cumulative data which
needs to be appended to SQL Server table. This program needs to identify
records that have not been previously inserted (there's a unique identifier
field) and only insert those. Also I must reuse our class ...

For a few days now, I've been unable to complete the Sql/OleDataAdpater conf wizard on VS .NET 2003 Architect. The message is : "the object reference is not defined on an object instance". Exception is raised by function Microsoft.VSDesigner.Data.VS.VsConnectionManager ...

I need to find out the structure of MS Access database;  tables, queries and
so on. How can I do that?
Direction or sample code would work.
Thanks to everyone in advance.

Hi there,
I'm running visual studio.net 2003, I am new to the software, so pls
be gentle.
I trying to add a typed dataset to a webform.aspx however every time I

I'm using the dataTable.Select() method in my code.
This is my code:
dft.Tables[0].Select("fieldName='" + @fieldName + "'") ;
This works fine until there is an apostrophe in the

Here's the scenario:
Object A opens a Sql Db connection to execute number of SqlCommands. Then it
needs to pass this connection to a constructor of object B which in turn
executes more commands on the same connection.

I have a collection of objects (eg Forms) , each of which contains another
collection (eg Controls). When I come to fill the Control collections at
startup, I fill each one in turn using a Form.GetControls(FormID) call. This
puts the call where I think it is best placed (In the Form ...

I get the following error message when I attempt to called query which
resides in my Access DB (Stored procedure), "Operation must use an updateable
query".  I looked at the KB article which addresses this error and it
indicates that I need to change the security on the folder ...

Hi testing the Visual Studio 2005 Beta 2, i'm developed one application and
save this project, when close the visual studio and reopen in another time
with the application i produce this error
OBJECT REFERENCE NOT SET TO AN INSTANCE OF AND OBJECT LINE 0 COLUMN 0

I wanted to ask how to get the default value defined in the DataBase,
to be defined as the default value in the DS scheme?
and if there isn't a way, how else can i do that?
thanks.

I have a dataset containing constraints. (not null, and size
constraints on table columns).
When the constraint is violated, a message box appears showing the
constraint violation.

I'm using a typed dataset where I have a common address table which is
related to several other tables in the dataset, see below:
Table Incident:
- PK

(Above there is the whole code.)
I have a dataset with 2 tables (father and child table) and a
relation between them with cascade for update and delete.
On this DataSet I delete a existing father's row and afterwards create the

If you call a stored procedure which is an update procedure, is it
autocommitted by default?
Is the same true for an Oracle Stored procedure?
If you call an Oracle Stored procedure with the defaults for the connection,