-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: saurabhmehta
Message 8 in Discussion
You cant use semicolon in SQL
statement.
Instead use line break. "\n" in C#
Check for equivalent in VB.
Regards,
Saurabh
----- Original Message -----
From:
MS_BJAIN
To: MumbaiUserGroup
Sent: Tuesday, January 06, 2004 8:12
PM
Subject: Re: Need...Urgent Please
...Value AutoNumber Field in ASP.NET
New Message on MumbaiUserGroup
Need...Urgent Please ...Value AutoNumber Field in
ASP.NET
Reply
Reply to Sender Recommend
Message 6 in
Discussion
From: MS_BJAIN
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()
View other groups in this
category.
-----------------------------------------------------------
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]
