. Reply (E-mail) Forward (E-mail)

Subject: Add row, ODBC and ADO.NET
From: "Marcus Olsson" <nospam (AT) nospam (DOT) se> Sent:
9/1/2003 8:08:17 AM




Hi!

I have a beginner problem and hope that someone easily
can solve my problem.

I want to connect to my Access database with ODBC. I have
downloaded MS ODBC library for connection with ODBC
from .NET.

It looks like I get the data and able to add the row, but
when I should update the source with the new data it
doesn't work.

Can you please give me a good link or tell me what's
wrong below.

Please help!

Code:

// Create a SQL statement
string mySelectQuery = "SELECT * FROM Bokning";

// ... a connection string
string sConnString = "Dsn=Bokning_new";

OdbcConnection oODBCConnection = new OdbcConnection();
oODBCConnection.ConnectionString = sConnString;

oODBCConnection.Open();

// Create a command object
OdbcCommand myOdbcCommand = new OdbcCommand
(mySelectQuery , oODBCConnection);

// Create an adapter, initialized with the command object
OdbcDataAdapter da = new OdbcDataAdapter(myOdbcCommand);

// Create a dataset
DataSet ds = new DataSet("bokning_new"); // Name could be
whatever

// Fill the DataSet with data from the database
da.Fill(ds);

DataTable myTable = ds.Tables[0];
//DataTable myTable = ds.Tables(0);

DataRow newRow = myTable.NewRow();
newRow["Date"] = DateTime.Today.ToShortDateString();

myTable.Rows.Add(newRow);

da.Update(ds);

// Close connection
oODBCConnection.Close();







Regards,
/Marcus
..

On Mon, 1 Sep 2003 08:42:41 -0700, "Marcus Olsson" <nospam (AT) nospam (DOT) se>
wrote:


Take a look at the OdbcCommandBuilder Class in the ODBC.NET help file.
Here is the sample code from that page.

Chris
--------------
Public Function SelectOdbcSrvRows(myDataSet As DataSet,myConnection As _
String, mySelectQuery As String, myTableName As String) As DataSet

Dim myConn As New OdbcConnection(myConnection)
Dim myDataAdapter As New OdbcDataAdapter()
myDataAdapter.SelectCommand = New OdbcCommand(mySelectQuery, myConn)

' ** You're missing this next line **
Dim custCB As OdbcCommandBuilder = New OdbcCommandBuilder(myDataAdapter)

myConn.Open()

Dim custDS As DataSet = New DataSet
myDataAdapter.Fill(custDS, "Customers")

' Code to modify data in DataSet here

' Without the OdbcCommandBuilder this line would fail.
myDataAdapter.Update(custDS, "Customers")

myConn.Close()

SelectOdbcSrvRows = custDS
End Function 'SelectOdbcSrvRows

Hil.

And I have very interesting problem.

I install ODBC for NET, but ditective Imports System.Data..... do not view
odbc library.


"Chris W." <GuamChris (AT) No (DOT) Spam.Yahoo.Com> wrote

Hi Yuriy,

You may have to browse for it when you set a reference to it.

HTH,

Bernie Yaeger
"Yuriy B. Belyaev" <jurijb (AT) mail (DOT) ru> wrote