Is this syntax correct I keep getting this error: -

Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.

here is my code: -


String strAuthor = Author.Text;
String strTitle = Title.Text;

String strSearch = String.Format("SELECT * FROM Computing WHERE BookAuthor LIKE '{0}' OR BookName LIKE '{1}'", strAuthor, strTitle);

OleDbCommand objCommand = new OleDbCommand();
OleDbDataReader objDataReader = null;

Connect();
       objCommand.Connection = objConnection;
       objCommand.CommandType = CommandType.Text;
       objCommand.CommandText = "Select * FROM Computing Where BookAuthor = ? AND BookTitle = ?";
       objCommand.Parameters.Add("BookAuthor", OleDbType.VarChar, 32,"BookAuthor");
       objCommand.Parameters.Add("BookName", OleDbType.VarChar, 128, "BookName");

       objCommand.Parameters["BookAuthor"].Value = Author.Text;
       objCommand.Parameters["BookName"].Value = Title.Text;
       objDataReader = objCommand.ExecuteReader();


if (objDataReader.Read())
{
         //dgComputing.DataSource = objDataReader;
         //dgComputing.DataBind();
}
objDataReader.Close();
Disconnect();


Adz - Portsmouth Massive

__________________
Adz - Learning The J2EE Ways.

Found this article on MSDN, it has some useful information that may help you out.

Peter
------------------------------------------------------
Work smarter, not harder.

Peter,

thanks, this article is a help with regards to writting my select statement for the commandtext property but I want some information on how to use the command. parameters.Add(.....) attribute how to code it, I cant seem to find anything on the net for it as well. Its can get frustrating. Any ideas

Adz - Portsmouth Massive

If you follow the right links in that article you should be able to get all the syntax assistant you need. For example... you could click on OleDbParameterCollection, then OleDbParameterCollection Members, then Add where you could find all the overloaded version of the Add method in 4 different languages.

I could go on...

Peter
------------------------------------------------------
Work smarter, not harder.

Thank you Peter,

Just need to look harder I guess, it shows all the examples I need. You star, thank you very much for your help. :)

Adz - Portsmouth Massive