dizzycat
asked on
SQLite parameters
Hi experts
Can someone show me how to write an sqlite parameter, here is the sql parameter i need to change to accept an sqlite patameter.
comm.Parameters.Add("@Name ", System.Data.SqlDbType.NVar Char)
comm.Parameters("@Name").V alue = txtName.Text
Hope somebody can help.
Can someone show me how to write an sqlite parameter, here is the sql parameter i need to change to accept an sqlite patameter.
comm.Parameters.Add("@Name
comm.Parameters("@Name").V
Hope somebody can help.
It should be the same. Are you receiving an error?
ASKER
Yes, it says there is a problem with the parameters
, I just thought that the sqlite parameters were
Different
, I just thought that the sqlite parameters were
Different
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I usually let .NET figure out the DB type, unless there is some problem where it can't. Does this work better?
comm.Parameters.Add(new SQLiteParameter("@Name", txtName.Text))
ASKER
That's great, thankyou.