|
|
 | | From: | Tatiana | | Subject: | SQL Commands | | Date: | 15 Jan 2005 17:42:12 -0800 |
|
|
 | Hello, do anybody know what is wrong in a code below?
connection.Open();
this.dsOprogramowania.Clear();
System.Data.OleDb.OleDbCommand command = new
System.Data.OleDb.OleDbCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT NazwaOpr FROM Oprogramowania WHERE
CONTAINS(Oprogramowania.NazwaOpr, ?);";
System.Data.OleDb.OleDbParameter parameter = new
ystem.Data.OleDb.OleDbParameter( "param" ,
System.Data.OleDb.OleDbType.VarChar ,50, "foundSoftware");
parameter.Value = foundSoftware;
command.Parameters.Add(parameter);
command.Connection = connection;
System.Data.OleDb.OleDbDataAdapter adapter = new
System.Data.OleDb.OleDbDataAdapter(command);
adapter.Fill(this.dsOprogramowania);
this.dbgOprogramowania.DataSource = this.dsOprogramowania.Tables[0];
connection.Close();
I suppose that i can't use such functions 'CONTAINS', which function
is the most appropriate ? Thank you for any help
|
|
| | From: | Gene Wirchenko | | Subject: | Re: SQL Commands | | Date: | Mon, 17 Jan 2005 12:33:52 -0800 |
|
|
| On 15 Jan 2005 17:42:12 -0800, statiana@poczta.onet.pl (Tatiana)
wrote:
>Hello, do anybody know what is wrong in a code below?
No, but I have comments that might help.
[snip]
>command.CommandText = "SELECT NazwaOpr FROM Oprogramowania WHERE
>CONTAINS(Oprogramowania.NazwaOpr, ?);";
^
That this is not quoted is suspicious.
>System.Data.OleDb.OleDbParameter parameter = new
>ystem.Data.OleDb.OleDbParameter( "param" ,
^^^^^
"System"?
>System.Data.OleDb.OleDbType.VarChar ,50, "foundSoftware");
[snip]
Sincerely,
Gene Wirchenko
|
|
|
