VB "System.Data.SqlDbType.Int" problem

phantom pooper

Hi,

Im kinda new to this whole programming thing, but i am getting a little trouble in one area. The Problem is where you see "System.Data.SqlDbType.Int", i think this is due to the fact i have changed the code here to work for an access db rather than sql server - but SqlDbType isnt valid. but ive been searching the net all day with no luck. any help would be greatley appreciated.


Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=" & Server.MapPath("~\db\digital.mdb")
Dim Conn As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(ConnectionString)

Dim comm As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand("INSERT INTO [SC2_tbl] ([UserID], [ProductID], [ProductName], [ImageS], [Date], [Price], [Quantity]) VALUES (@UserID, @ProductID, @ProductName, @ImageS, @Date, @Price, @Quantity)", Conn)

comm.Parameters.Add("@UserID", System.Data.OleDb.NChar, 36)
Comm.Parameters("@UserID&quot.Value = Session("UserID") 'Set in Global.asax
Comm.Parameters.Add("@ProductID", System.Data.SqlDbType.Int)
Comm.Parameters("@ProductID&quot.Value = ProductID
Comm.Parameters.Add("@ProductName", System.Data.SqlDbType.VarChar, 50)
Comm.Parameters("@ProductName&quot.Value = ProductName
Comm.Parameters.Add("@ImageS", System.Data.SqlDbType.VarChar, 50)
Comm.Parameters("@ImageS&quot.Value = ImageS
Comm.Parameters.Add("@Date", System.Data.SqlDbType.SmallDateTime)
Comm.Parameters("@Date&quot.Value = SaleDate
Comm.Parameters.Add("@Price", System.Data.SqlDbType.SmallMoney)
Comm.Parameters("@Price&quot.Value = Price
Comm.Parameters.Add("@Quantity", System.Data.SqlDbType.Int)
Comm.Parameters("@Quantity&quot.Value = Quantity

Try
conn.Open()
Comm.ExecuteNonQuery()
Catch ex As Exception

sobriquet

What error are you getting? I assume it's an exception of some sort?

For the UserID you use System.Data.OleDb.NChar - are there corresponding OleDb.whatever enumerations for other types? If so you might need to change all the subsequent SqlDbTypes to those.

Yeah, quick google of OleDbType seems to confirm that that's what you'll want to use.

ob

You could use addwithvalue:


Instead of this:

comm.Parameters.Add("@UserID", System.Data.OleDb.NChar, 36)
comm.Parameters("@UserID&quot.Value = Session("UserID") 'Set in Global.asax

Try this:

comm.Parameters.AddWithValue("@UserID", Session("UserID"))