sqldata adapter

[komalcse]

I am using Asp.Net and C# with SQL Am using sqldataadapter and dataset to diaplay the records from the database but i want to display the error message when there is no records in the database how to do that can anyone help plz komal

[Sherin Iranimose]

Hi, rccount = (int)DS.Tables("YourTable").Rows.Count

**$**herin Iranimose

[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

[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

[NanaAM]

Create one label outside grid. And when your foreach loop enda, just check grid.rows.count. If its 0 then directly display 'No records found' msg in the label

Nana

[N a v a n e e t h]

$herin wrote:

rccount = (int)DS.Tables("YourTable").Rows.Count

Property Count return an integer value, no need of explicit conversion here.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

[Sherin Iranimose]

Thanks...

**$**herin Iranimose

[komalcse]

i have used databind to the grid how can i use this condition

[NanaAM]

Afer binding you can still check it.

Nana