Adora Krause

Adora Krause

  • NA
  • 41
  • 11.6k

Error in execution of SQLite Parameter class in SQLite

Feb 13 2012 12:21 AM
Hi everyone. I m implementing the code for SQLite Parameter class. My code is as follows:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Devart.Data.SQLite;
using Devart.Common;
using System.Data.Common;

namespace ConsoleApplication18
{
  public class SQLiteParameter: DbParameter
   
  {
    public void AddSQLiteParameters()
    {
      SQLiteConnection con=new SQLiteConnection(@"d:\cust");
      SQLiteDataSet ds=new SQLiteDataSet();  
      SQLiteDataAdapter da=new SQLiteDataAdapter("Select * from cust",con);
      da.SelectCommand.Parameters.Add("P_Name", SQLiteType.Text).Value = "neha";
      da.Fill(ds); 
    }
    static void Main(string[] args)
       {
         
       }
    }
}
 
When I try to execute the above written code, it says "Error 19 'ConsoleApplication18.SQLiteParameter' does not implement inherited abstract member 'System.Data.Common.DbParameter.DbType.get'. So please help me in solving this error.

Thanks.