-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SelvanDotnet
Message 4 in Discussion
Hi Balaji, Use DataAdapter to update your data to SQLServer. Here this sample code
written in VB.NET hope its very easy to update in C#. protected objAdapter As
System.Data.OleDb.OleDbDataAdapter
Dim dSet As New DataSet // Dataset (dset can be from any Datasource) Fill
Goes Here // Dim OleCmd As New OleDb.OleDbCommand
OleCmd.CommandText = "PROCEDURE_SELVAN"
OleCmd.CommandType = CommandType.StoredProcedure
Dim prmItem As OleDb.OleDbParameter = New
OleDb.OleDbParameter("@prmAuthor", System.Data.OleDb.OleDbType.VarWChar, 10,
ParameterDirection.Input, True, 0, 0, "", DataRowVersion.Default, Convert.DBNull)
prmItem1.Value = "Tamilselvan Subramanian"
OleCmd.Parameters.Add(prmItem)
OleCmd.Parameters.Add("@ID", OleDb.OleDbType.VarChar, 15, "ID")
OleCmd.Parameters.Add("@NAME", OleDb.OleDbType.VarChar, 20, "NAME")
OleCmd.Parameters.Add("@LNAME", OleDb.OleDbType.VarChar, 15, "LNAME")
objAdapter.InsertCommand = OleCmd
objAdapter.InsertCommand.Connection = conMyConnection
intUp = objAdapter.Update(dSet, "TABLE_NAME") ' intUp returns No of Records Inserted
in '
TABLE_NAME Regards , Tamilselvan Subramanian
-----------------------------------------------------------
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]
