Datagrid

[Andy]

i would make your sub return a boolean. that boolean is determined on whether or not the dataset has data. then, when you call that function, you can display a message box if it returns false.

[Andy]

private bool  BindSearchData(string strSearchSql)
	{

          OleDbConnection scnnNW = new OleDbConnection(SQL_CONNECTION_STRING);
	
	  OleDbCommand scmd = new OleDbCommand(strSearchSql, scnnNW);
			
	  OleDbDataAdapter sda = new OleDbDataAdapter(scmd);

	  DataSet ds = new DataSet();

	  if (sda.Fill(ds) = 0)
{return false;}

	  dgCompany.DataSource = ds;
	  dgCompany.DataBind();

        }

[Andy]

oops! the code should read like this

private bool  BindSearchData(string strSearchSql)
	{

          OleDbConnection scnnNW = new OleDbConnection(SQL_CONNECTION_STRING);
	
	  OleDbCommand scmd = new OleDbCommand(strSearchSql, scnnNW);
			
	  OleDbDataAdapter sda = new OleDbDataAdapter(scmd);

	  DataSet ds = new DataSet();

	  if (sda.Fill(ds) == 0)
{return false;}

	  dgCompany.DataSource = ds;
	  dgCompany.DataBind();

        }