Guys I am tring to search my data source. Everytime I press the button nothing is displayed. I have stored the textbox entries into string variables and then entered them into a select statement. and then used a dataset set filled it using the data adapter with the entries which were selected using the modified select statement and then display this in a datagrid. No result though. I think that it maybe due to how I store the textbox values. Here is my code: -

private void Button_Click(object sender, System.EventArgs e)
{
  String strAuthor = Author.Text;
  String strTitle = Title.Text;

  Connect();
  String strSearch = "SELECT Computing Where BookAuthor = " + strAuthor + " OR BookTitle =" + strTitle;
  OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
  DataSet ds = new DataSet();
  objAdapter.Fill(ds, "dtFilteredComputing");
  Disconnect();

  dgComputing.DataSource = ds.Tables[0].DefaultView;
  dgComputing.DataBind();
}

THanks

Adz

Adz - Portsmouth Massive

__________________
Adz - Learning The J2EE Ways.

You need to specify the table that you are pulling the data from.
Make:

SELECT Computing Where BookAuthor = "

something like:

SELECT Computing FROM [tablename] Where BookAuthor = "

J

I also noticed another possible problem in these two lines:

String strSearch = "SELECT Computing Where BookAuthor = " + strAuthor + " OR BookTitle =" + strTitle;

OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);

Your SQL string is declared as "strSearch", but in the 2nd line you use "strSQL".

I don't use C#, but I assume the syntax should be pretty similar. I am also assuming that your connection has already been established because I don't see a connection string...

J

I think I see where you connect now. I believe that you call a Connect() and Disconnect() function, correct? Anyway, I hope those suggestions I gave help.

J

thanks but i have solved it

Adz

Adz - Portsmouth Massive