Why would this fail(using int64/BigInt):
   Dim mParmValue As System.Int64 = 133
   Dim mParm As New System.Data.SqlClient.SqlParameter("@UserID",
System.Data.SqlDbType.BigInt)

greeting,
attach below are my codes for a sqldatareader method, it returns a
sqldatareader. if you notice, i have my close connection in the finally
method. anyway, since its returning a sqldatareader, i cannt read it and i

I have two tables in different servers that i need to do a join on:
Server1:
employees1
  -employeeID

I am trying to write a program to create a database by executing the T-SQL
statments for the databases Tables, Views Stored Procedures etc.  I have a
file that contains all the T-Sql Script. The program I have written will
create the tables ok, the views and even some of the ...

I have some queries with a command time out of some 10 minutes. This is
taking solong that users offen think the app is hanging. To prevent them of
complaining i want to display an progress indicator. Is there anyone who can
tell me on how to deal with this in asp.net and ado.net. ...

  I have wrote a test application to access class library from different
location and the configuration file created through .NET framework
configuration looks like this
<?xml version="1.0"?>

Is there a specific way in ado.net of trapping an attempted (Access)
database update by da.update that would otherwise result in a record
with a duplicated primary key? The exception generated seems to be
OleDbException which isn't a very specific exception to trap, since it

I have two tables set up in a parent-child relationship that I display in
the datagrid. I can edit and update the child data columns directly in the
grid -- but not the parent data, as those parent columns are read-only.
Private Sub FillGrid()

Please Enter MS JET OLE DB Initialization information
I tried to create an oledb DataAdapter today.  As usual it asked me to
choose a database.  I did.  Then for the first time when I clicked next a
second form came on the screen.

hey guys, for so long i've been using the Server Explorer to make the connection, config
the adapter and the dataset (just like i was taught in school), but that's not really the real world.
so, i started doing this all in code, which is great.
but, it means that the table, columns ...

I've moved some code for updating an Access database from an old
project (no longer to hand unfortunately) to a new one and keep
getting an 'Update requires a valid InsertCommand when passed DataRow
collection with new rows'.

I have to warn that I am a .Net novice and in fact don't use ADO.NET in the
"traditional" way but via access to a Progress (www.progress.com) AppServer
via proxies that they allow you to build.
I have been playing with creating a program where I get data into a dataset

I have table with 5 columns. ID (int) and "Name, LastName, FatherName,
Phone" as text field. In that table I have 200000 records. Also I have view
with statement
Select (Name + LastName + FatherName + Phone) as Search

I am parsing column names from text files and building CREATE TABLE and INSERT statements at run-time using these names.  I have no control over the data written to the text files.
When building my SQL statements, I bracket all column names (e.g. "[" + name + "]").  However, this ...

Does calling IDataReader.Close() close the DataBase Connection?
Thanks!