problem with project

use function

public void GetNoofData(string Query,TextBox tx)
{
//-- excecute your Query and set data in Textbox tx 
}

call like that

GetNoOfData("select count(UrFieldName) from UrTableName",txt);

GetNoOfData("select count(UrFieldName) from UrTableName1",txt1);

Hi,
The best way to solve your sollution what i can suggest is.

a) write generic function/ method in your DAL to fetch data from tatabase in a dataset. like following

public int GetCount(string tablename, string field)
{
//// tablename = database table name
//// field = field on which count is required
}

or

public dataset GetData(string tablename, string querystring)
{
//// tablename = database table name
//// querystring = query to fetch your desired data in a data set.
}

Now in the UI part
b) if it is count that you want then you can directly fetch from the return of GetCount function.

else you can get a dataset which can be further used to fetch data from to be inserted into the textbox as the following code.

Dataset retDataset = objDAL.GetData("yourTAble", query);
txtDesired.Text = retDataset.Tables["yourTAble"].Rows[0]["field"].ToString();

Hope this will guide you to correct path solving your problem.
Thanks
Amit Dutta