how to use parameters for Odbc using MS Access

Question

User1052662409 posted

HI all,

        Actually used to use Sql server, for that I add parameters like this

com.Parameters.Add("Field1",SqlDbType.Nvarchar,50).value=TextBox1.Text.

that works fine.

but while using MSaccess and the datatype for of some table is Memo than how could I use parameter for that i am using System.Data.Odbc.

cos here it is easy to do SqlDbType.Nvarcha cos there is shows Nvarchar but not Memo

let me know the difference to use parameter for Odbc database

thanks

Answer 1

User1508394307 posted

I think you should use OdbcType.Text

Answer 2

User-1199946673 posted

but while using MSaccess and the datatype for of some table is Memo than how could I use parameter for that i am using System.Data.Odbc.

 

Use OleDB instead of Odbc! When you use Parameters.AddWithValue you don't have to worry about the datatype! Examples of how to use Access with parameterized queries can be found here:

http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

Answer 3

User1052662409 posted

thanks...