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

Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole
DB Services=-4; Data Source=C:\Documents an"& _
"d Settings\AliceLee\My Documents\db\equipment.mdb"
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "INSERT INTO [test]
([SerialNumber]) VALUES (SerialNumber1)"
Dim dbCommand As System.Data.IDbCommand = New
System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close

End Try

'Return rowsAffected

it returned--> Exception Details: System.Data.OleDb.OleDbException: 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.text into access???

[quoted text, click to view]

¤ i am beginner to link asp.net and access 2gether
¤ i use asp .net matrix...and wrote the Insert data coding
¤
¤ Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole
¤ DB Services=-4; Data Source=C:\Documents an"& _
¤ "d Settings\AliceLee\My Documents\db\equipment.mdb"
¤ Dim dbConnection As System.Data.IDbConnection = New
¤ System.Data.OleDb.OleDbConnection(connectionString)
¤
¤ Dim queryString As String = "INSERT INTO [test]
¤ ([SerialNumber]) VALUES (SerialNumber1)"
¤ Dim dbCommand As System.Data.IDbCommand = New
¤ System.Data.OleDb.OleDbCommand
¤ dbCommand.CommandText = queryString
¤ dbCommand.Connection = dbConnection
¤
¤ Dim rowsAffected As Integer = 0
¤ dbConnection.Open
¤ Try
¤ rowsAffected = dbCommand.ExecuteNonQuery
¤ Finally
¤ dbConnection.Close
¤
¤ End Try
¤
¤ 'Return rowsAffected
¤
¤ it returned--> Exception Details: System.Data.OleDb.OleDbException: 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.text into access???

The database engine can only evaluate SerialNumber1 as a constant value or a query parameter. The
value must be derived when constructing the SQL string, prior to execution.

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


Paul
~~~~

Dim connectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
Source=C:\Inetpub\wwwroot\db\equipment.mdb"
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "INSERT INTO [test]
([SerialNumber]) VALUES ('"& SerialNumber1.text &"')"
Dim dbCommand As System.Data.IDbCommand = New
System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try

but it return error msg like this
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Operation must use
an updateable query.

[quoted text, click to view]

¤ Dim connectionString As String =
¤ "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
¤ Source=C:\Inetpub\wwwroot\db\equipment.mdb"
¤ Dim dbConnection As System.Data.IDbConnection = New
¤ System.Data.OleDb.OleDbConnection(connectionString)
¤
¤ Dim queryString As String = "INSERT INTO [test]
¤ ([SerialNumber]) VALUES ('"& SerialNumber1.text &"')"
¤ Dim dbCommand As System.Data.IDbCommand = New
¤ System.Data.OleDb.OleDbCommand
¤ dbCommand.CommandText = queryString
¤ dbCommand.Connection = dbConnection
¤
¤ Dim rowsAffected As Integer = 0
¤ dbConnection.Open
¤ Try
¤ rowsAffected = dbCommand.ExecuteNonQuery
¤ Finally
¤ dbConnection.Close
¤ End Try
¤
¤ but it return error msg like this
¤ Operation must use an updateable query.
¤ Description: An unhandled exception occurred during the execution of
¤ the current web request. Please review the stack trace for more
¤ information about the error and where it originated in the code.
¤
¤ Exception Details: System.Data.OleDb.OleDbException: Operation must use
¤ an updateable query.

The account under which your web app is running probably doesn't have sufficient permissions to
modify the database. See if the following helps:

http://support.microsoft.com/?scid=kb;en-us;316675&spid=2514&sid=228
http://support.microsoft.com/default.aspx?scid=kb;en-us;307901


Paul
~~~~