Oledb parameterized query sqlserver ce does not support?

• sujithapril

  SSC Enthusiast

  Points: 115

  More actions

  February 11, 2009 at 12:07 am

  #197023

  OleDbConnection con = new OleDbConnection(constring);

  con.Open();

  string qry2 = "select * from [dbo.TblCategory] where Name=?";

  OleDbCommand cmd = new OleDbCommand(qry2, con);

  System.Data.OleDb.OleDbParameter p = new OleDbParameter("@p1", OleDbType.VarWChar);

  p.Value="demo";

  cmd.Parameters.Add(p);

  OleDbDataReader rdr = cmd.ExecuteReader();

  It throws error type is not supported.when i use SqlCeCommand ,error does not occurs. i need it to work with Oledb anuy idea?

  i use sqlserver 2005 compact edition.c#.net 2.0

• spidergen

  SSC Enthusiast

  Points: 115

  More actions

  August 7, 2009 at 1:07 am

  #1035804

  Hey,

  I've got a similar problem. But in my case, it isn't working with more than one parameter:

  http://social.msdn.microsoft.com/Forums/de-DE/sqlce/thread/28a24ce8-6b54-4e8a-af77-58fa91b497e3