-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: MS_BJAIN
Message 6 in Discussion
Thank you for response.
I tried this code.. but return an error "Characters found after end of SQL statement.
". Where am I wrong? Please see
Dim OLEDBConn As New OleDbConnection()
Dim OLEDBcomm As New OleDb.OleDbCommand()
OLEDBConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User
id=Admin;Password=;Data Source=" & Server.MapPath("../admin/NorthWind.mdb") & ";"
OLEDBConn.Open()
OLEDBcomm.CommandType = CommandType.Text
OLEDBcomm.Connection = OLEDBConn
OLEDBcomm.CommandText = "Insert INTO TempAuto(description) values('" & TextBox1.Text &
"');SELECT @@IDENTITY;"
'Response.Write(OLEDBcomm.CommandText)
TextBox2.Text = OLEDBcomm.ExecuteScalar()
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_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]
