|
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 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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Here you have to check the count of records for bot the datatables separately and display the message accordingly.
Apurva Kaushal
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Hi,
rccount = (int)DS.Tables("YourTable").Rows.Count
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
i have used databind to the grid how can i use this condition
|
|
|
|
|
Afer binding you can still check it.
Nana
|
|
|
|
|
$herin wrote: rccount = (int)DS.Tables("YourTable").Rows.Count
Property Count return an integer value, no need of explicit conversion here.
|
|
|
|
|
|
Hello everyone,
I have a page Main.aspx. When I click on a button, it opens a modal dialog by using javascript:
window.showModalDialog(Modal.aspx,... );
That works well.
Then, on the modal page, Modal.apsx, I have a gridview filled in the code-behind to get data from a database.
That works.
When I close the Modal page, I come back to the Main page, great.
Now is the problem ...
When I re-open the modal dialog, it appears again but doesn't run the code-behind!
Does someone know why?
That's annoying as I cannot get the updated data from the database (updated previously with the modal dialog I first opened).
I hope someone will have the answer to how to correct that ...
Thank you!
|
|
|
|
|
Does the page_load event of Model.aspx fire when you open the modal dialog?
Do you think that it's because of Cache??
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
The event fires the really first time I open the modal dialog. Then, it doesn't fire.
If I restart the website (still in debug mode in VS), it works again, the first time I fire it.
I also thought of a cache problem or trick ... but I don't really know of to check that in asp.net ...
Could tell me more about it?
Thank you for your interest!
|
|
|
|
|
i'm currently developing a student portal using ASP .Net and webforms. and i use to bind all the data from database in the textbox. i have no problem in binding the data to the textbox but problems rise when navigating the data (eg.next,previous,last,first). i hd used this coding (for next):
for(int i=0;i
|
|
|
|
|
What exactly do you mean by "webform is not running properly."
Nana
|
|
|
|
|
well, after i click the load button, the first row will load to the bounded textboxes. then, when i click the next button to display the next row it will stuck in the middle of the process. like, its hang halfway and it seems not going to finish. i hope you get what i mean...thanx.
|
|
|
|
|
sory..the coding is not complete.
for(int i=0;i<dataset11.tables["table"].rows.count;i++)
{
oledbdataadapter1.fill(dataset11,"tables1");
page.databind();
}
okey...i found="" two="" lines="" of="" coding="" about="" navigating="" the="" database="" but="" they="" are="" written="" in="" vb="" language.="" i="" don't="" know="" to="" convert="" it="" c#="" nor="" use="" it.
dataset.tables("table").rows(0).item("field")="" ---="">this will return the first record.
dataset.Tables["table"] .Rows.Count()--->this will return the total number of rows.
|
|
|
|
|
Hello Friends,
My client wants online chatting to other clients.So i want to include chat in my project.How i chat with different online users by conference.Please send some tips related to this question.If i add a user and chat with him by conference.Please send code related to this..Please avoid my query and mail it.Thanks
|
|
|
|
|
SreejithAchutan wrote: Please avoid my query and mail it.
hum? what?
SreejithAchutan wrote: .So i want to include chat in my project.
You mean, you wanna include the chat application in your project, right?
Search in CP
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|