adding data...got problem....pls help

[zheetee]

i am beginner to link asp.net and access 2gether
i use asp .net matrix...and wrote the Insert data coding

Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\Docum ents an"& _
"d Settings\AliceL ee\My Documents\db\eq uipment.mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)

Dim queryString As String = "INSERT INTO [test]
([SerialNumber]) VALUES (SerialNumber1) "
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection

Dim rowsAffected As Integer = 0
dbConnection.Op en
Try
rowsAffected = dbCommand.Execu teNonQuery
Finally
dbConnection.Cl ose

End Try

'Return rowsAffected

it returned--> Exception Details: System.Data.Ole Db.OleDbExcepti on: No
value given for one or more required parameters.

SerialNumber1 is a textbox that i using in the asp.net page....

can i know what is the problem???
why cant get the add the SerialNumber1.t ext into access???

[Peter Bromberg [C# MVP]]

If "SerialNumb er1" is a textbox control, then its value should be

SerialNumber1.T ext

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"zh*****@gmail. com" wrote:

i am beginner to link asp.net and access 2gether
i use asp .net matrix...and wrote the Insert data coding

Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\Docum ents an"& _
"d Settings\AliceL ee\My Documents\db\eq uipment.mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)

Dim queryString As String = "INSERT INTO [test]
([SerialNumber]) VALUES (SerialNumber1) "
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection

Dim rowsAffected As Integer = 0
dbConnection.Op en
Try
rowsAffected = dbCommand.Execu teNonQuery
Finally
dbConnection.Cl ose

End Try

'Return rowsAffected

it returned--> Exception Details: System.Data.Ole Db.OleDbExcepti on: No
value given for one or more required parameters.

SerialNumber1 is a textbox that i using in the asp.net page....

can i know what is the problem???
why cant get the add the SerialNumber1.t ext into access???

[Jeff Dillon]

You need to concatenate your SerialNumber1.T ext value into your string.

Practice on a program that doesn't connect to the database, and learn how to
build strings.

Dim queryString As String = "INSERT INTO [test] ([SerialNumber]) VALUES ('"
& SerialNumber1.T ext & "')"

<zh*****@gmail. com> wrote in message
news:11******** *************@u 72g2000cwu.goog legroups.com...

i am beginner to link asp.net and access 2gether
i use asp .net matrix...and wrote the Insert data coding

Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\Docum ents an"& _
"d Settings\AliceL ee\My Documents\db\eq uipment.mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)

Dim queryString As String = "INSERT INTO [test]
([SerialNumber]) VALUES (SerialNumber1) "
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection

Dim rowsAffected As Integer = 0
dbConnection.Op en
Try
rowsAffected = dbCommand.Execu teNonQuery
Finally
dbConnection.Cl ose

End Try

'Return rowsAffected

it returned--> Exception Details: System.Data.Ole Db.OleDbExcepti on: No
value given for one or more required parameters.

SerialNumber1 is a textbox that i using in the asp.net page....

can i know what is the problem???
why cant get the add the SerialNumber1.t ext into access???