I'm having some trouble with an insert back to a datasource using the the
insertcommand built by commandbuilder.  I suspect it may be a slight problem
with the insert statement.  Is there any way to see the actual insert
statement that commandbuilder creates?

Where is the problem?
Find Below
•Exception
•Stored procedure

Hi - I have a very large database (65535 entries) and need to call this
database as often as every 100ms - Oledb and Access use WAY tomuch CPU and I
needsomeadviceon how toimplement a VERY fast data access system - is it
quicker to use a text file? - or isit better to use xml?- ...

I am having problem inserting rows in a table with identity column.
One columen is an Id field with identity set to true.
I insert values into the other column and the column with identity set
to true is updated with correct new values.

I have read numerous posts on this question, but would like to ask it again
for clarification or additional input.
We have a vb.net app connecting to mssql2000 primarily through stored
proceedures.

when i want binding a textbox to a untyped dataset by this cod:
  .
  .
  Dim Ds as New DataSet

I am opening a connection on a shared db as below which works fine when used
in a vb.net win app.
Conn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\Events Data\Events Data.mdb;User Id=admin;Password=;")

Every application uses data. Join members of the Visual Studio and SQL teams
for a discussion of the best approaches for working with data in your
applications.
Date:

I've been told that the experts here will be able to help me :)
I'm using VB.NET and SQL Server.
I'm using stored procedures to update and create new records in my database.
On the form I'm working on, I have 2 date fields.

Hi, friends,
I have stored procedure which will return the new userID:
CREATE PROCEDURE dbo.sp_InsertUser
               @lastName            VARCHAR(50),

I have a problem using a stored procedure that insert a new record and
set the value of an output parameter to the new ID.
The insert works fine but the output parameter is always 0.
Here is the sp code :

I'm learning VB.net and have a question..
I'm trying database access at the moment, and so far have managed to create
and fill a dataadapter. I can then bind that to a windows control ok and
see/naviagte the records.

I am trying to populate a dropdown combobox using:
Dim GetSQL As String = "Select QID, QuestionTypes " & _
                                      "From QuestionTypesList " & _
                                      "Order By QuestionTypes"

   my webservice read from (and write to) Oracle queues. It uses the
Oracle Data Provider downloaded from Oracle site (Oracle10g Data
Provider for .NET 10.1.0.2.0). Webservice calls a stored procedure
that executes the read operation. Sometimes the ExecuteNonReader()

i am developing a database application with sqlserver2000 where users
can enter search strings manually.
So it is possible that the result gets really big, to big for a website.
is it possible to restrict a datatable to a defined number of rows, or