try this...
protected void btnSearch_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string connectionString = (string)ConfigurationManager.ConnectionStrings["DeemahTestConnectionString"].ConnectionString;
ConnDeemah.ConnectionString = connectionString;
string sqlQuery = "select top(1) * from itemMaster where ItemDescription like '%+txtSearch.Text+%' ";
SqlDataAdapter da = new SQLDataAdapter(sqlQuery, ConnDeemah);
da.Fill(ds);
if(ds.Tables[0].Rows.Count > 0)
{
TestGrid.DataSource = ds;
TestGrid.DataBind();
}
else
{
'print message no result found
}
}
Please check the case using intellisense, I have not used any editor so may be misspelled.
Hope this helps