data adapter: error meassage

[komalcse]

i have binded the records from the database and its working, but i have written a query to sum a column and display in different column, so totally 2 tables should be binded, i have binded using 'foreach' i don't know how to get the error message

[_AK_]

komalcse wrote:

but i have written a query to sum a column and display in different column, so totally 2 tables should be binded, i have binded using 'foreach'

Bind to what?

Apurva Kaushal

[komalcse]

Hi, i have 2 tables in my database ihave used text boxes in My code behind to display it.(asp.net and c# with sql) i have given sql connection using data adapter and dataset i can view the datas from the database my doubt is how can i show the error message if there is no information in the database

[_AK_]

If you are using dataset then you can check the rows.count property. If it is returning 0 then there is no records in the database.

Apurva Kaushal

[komalcse]

yes its works Thanks a lot but i have another question now i have two tables in my database, am not using the gridview to display the information am using textbox, how can i display the error message now i have used, DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) and DataTable dt = ds.Tables[1]; foreach (DataRow dr in dt.Rows) how to display the message

[_AK_]

Here you have to check the count of records for bot the datatables separately and display the message accordingly.

Apurva Kaushal

[komalcse]

Let me repeat my question: 2 tables from the database should be binded to my textboxes separately can u explain me wit an example so that i can undersatnd better plz thanks, komal