Datagrid

[sinha]

Hi!

I have to search my database and display the search results in the datagrid.
Its happening fine. I have created a subroutine BindSearchData() and calling it from the Click event of a button. The routine takes the query as an argument. Follwing is the code

private void 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();

	  sda.Fill(ds);

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

        }

My problem is that when no records are found. I have to show it as a message " No Records found." I am coding in c# and a newbie.

Pls help.

[fret]

not sure though, but you can do this by checking the dataset if fills data on it.

this.dataGrid1.DataSource = ds;
 
            if(ds.Tables.Count>0)
                if(ds.Tables[0].Rows.Count>0)
                    MessageBox.Show("Records found");
                else
                    MessageBox.Show("No records found");

[sinha]

Thanks! It really helped.

[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();

        }