i not unterstand the expression {oColPk}, see Row 18. What do have the
braces with the instantiation a DataColumnobject?

 1 Private Sub Test()

I am experimenting with ADO.NET
I use MySQL 3.23 with MyODBC 3.51
At the moment I simply try an insert a select and an update. I use the
usual DataSet approach. The select works and retrieves the data from the

I have a SQLDataAdapter created with the wizard and having all of the
commands including the DeleteCommand - I used the defaults.
To delete a record, this works just fine:
       myDA.SelectCommand.Parameters("@mykey").Value = mykey

I have a DataForm bound to a dataSet "dsPhoneBook".  I want to have a button
"btnFind"on my form open a input box where I can enter a name and the record
be set to the name I entered into the input box.  I can not figure out how
to do this.  Need Help!

I have sucessfully used Reader.GetSchemaTable() to dynamically discover C# types from populated database tables. However, I need to determine the C# data type for the columns of empty tables in order to populate them. I have attempted to use GetOleDbSchemaTable(OleDbSchemaGuid ...

Hi. I have the following requirement and I don't know which way I should approach it
In a 3 tier application, the business layer calls a function in the data access layer; the data access layer function opens an Oracle connection, execute an "ExecuteScalar" instruction, closes the ...

i have and asp.net application that uses an access database
i use dbcom for database application  for ex
Imports Syste
Imports System.Dat

I need to support a VB6 application that will be receiving
disconnected ADODB.Recordset from out DotNet solution.  Our dotnet
solution deals with System.Data.DataTable.  I need to populate a
disconnected ADODB.Recordset from System.Data.DataTable data.  Below

I'm adding a DataColumn to my DataTable with a given expression:
"column1/column2". But sometimes it occurs that in some rows, value of
column2 is 0. Then while adding my expression column, program throws
DivisionByZeroException.

can i get information regarding precision and scale from datacolumn, without using adapter
regards, and thanks in advance
seril

I want to inser a Text string as a BLOB
When I try to insert a series of records I get the following problem
 -- System.Data.SqlClient.SqlException: String or binary data would be truncated
My table has three nvarchar 50 columns, (MessageId, PutDate, MsgType

I'm migrating a legacy, reporting-type application (ODBC) to use ADO.NET in
order to facilaite ASP.NET delivery.  The problem I have is that some of the
reports this old app runs relies heavily on creating temporary tables to
hold intermediate results of complex select expressions.  ...

I am using VS.NET 2003. I have a function that runs a procedure and
returns a SqlDataReader:
Public Overloads Function RunProcedure(ByVal StoredProcName As String,
_

How Can I execute a SQL Sentence from ADO.NET?
Thanks!

I have a memo field in my Access database that is called HtmlText.
I have a text box in my ASP.NET application that I fill with HTML.  The HTML
has both single and double quotes throughout the HTML.
I tried to run an UPDATE query to update the db but it fails.  I think it's