I'm having problem opening SqlConnection after MSDE reinstallation.
In the following snippet:
SqlConnection cnn = new System.Data.SqlClient.SqlConnection( );
cnn.ConnectionString = "Connect Timeout=30; Initial Catalog=master; Packet

I am new to .Net and ADO.NET. I used Visual Studo .Net to create a
Oracle DataAdapter. Now I want to bind to a DataGrid to display the
result of the SQL Statment. I tried the following source code but it
does not work :-(

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

MS documentation says that DbType.String is implicity converted to
NVarChar. But this implicit conversion will fail if the string is
greater than the maximum size of an NVarChar, which is 4000 characters.
For strings greater than 4000 characters, explicitly set the SqlDbType.

I have a DataTable that has 240000 rows in it.  My DataTable.Select Method
for a particular filter gets me 840 out of 240000 rows.  However, it takes
about 5 seconds to process.  The DataTable has 6 columns.  The datatype for
the columns are number(10), number(10), varchar2(2000), ...

I am trying to setup a database class and curious how you would deal with
parameters?
Part of the class looks like:
***********************************************************************

I am trying to insert data into an "access" table programmatically.
Sometimes I get the following message:
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."

I mean to create a new column with Integer type, which is defined by its
expression to be Year/Month/Date of a DateTime Column.
Of course, It is simple to define such a new column by
Substring(Convert(DateTimeColumn,"System.String"),x,y) to get  

Is there a way to do a syntax check on the statement without executing it?
Cathie

I've got a DataTable called dtOrders that is populated with orders from
an Access table. There is an associated DataView called dvOrders, which
stores a single record (the current order).  I have several text fields
bound to this DataView, as follows:

I have searched vbcity and the internet for a solution for my question
but with no luck. But I am sure it must be simple to accomplish?
I have to Datatables, DT1 and DT2, already populated from database.
What I want to do is to select data from two (or more) datatables (in

I have a whole set of of small, very fixed tables that i'd like to treat in
much the same way.
1) Mock up in XML
2) Create the Schema

I am looking for an approach (or preferably some example code ;-) to "dump"
a DataSet in a compressed (binary?) and encrypted (simple algorithm will do)
file, reversable of course - i.e. a sort of "BinaryDataSet" derived from
DataSet and with overloaded methods for WriteXml() and ...

I'm trying to load a schema ReadXmlSchema with defined key and relation
into a dataset but the result is that VS adds the _Id column anyway what am
I doing wrong?
Regards, Joel

Is there any tool that automatically generates code for Data Access
component based on existing database table?
Thanks,
Alan