-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: KartikKrish
Message 3 in Discussion
Dim conLath As OleDbConnection
Dim cmdLath As OleDbCommand
Dim dapLath As OleDbDataAdapter
Dim dstLath As DataSet
conLath = New OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\tower1\home01\nlms1\datab2000\latham2000.mdb")
dapLath = New OleDbDataAdapter ( _
"select lineno,year,text from text30s40s", _
conLath)
dstLath = New DataSet()
dapLath.Fill(dstLath,"text")
u can now use DataTable datatbl=dstLath.Tables("text") as datatable and use the
previous code. datatbl.Rows.Remove will help you in removing rows. AcceptChanges()
method commits any changes to the dataset. ADO.net always maintains two copies of
the dataset,IIRC.One original, and one is the current version.When you commit
changes,the contents of the original are updaed. The update method of dataadapter
calls the appropriate statement for each row changed. I suggest you look at->
http://www.microsoft.com/sverige/nr/rdonlyres/8F51EDD5-23AD-49D6-B491-30F1DA57C701/1984/ADOdotNET.ppt
an excellent presentation by Microsoft. Kartik
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
