I'm having a problem with datatable after i passed it to a function using byval in the page load. Inside the function I remove some of the rows that are not needed for that function. But i noticed that the original datatable rows in the page load was also deleted.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim ds as New datatable
Dim data as New datatable
'This part loads the data from the database using oracledatareader with a name "reader"
'Total datatable rows = 50
You pass a DataTable to a function, manipulate it, then pass it back - and are surprised to see your changes? What did you expect? If you don't want to see changes, pass it to a Sub (Procedure) instead of a funxtion. (Or simply pass back True or something instead of the DataTable)
In a website the result of students can be accessed only by their respective ID numbers! there is no other way to access the database. like the website shows a textbox with a submit button and the textbox only accepts a number i.e. the ID of student.
I want to grab all the result that is a way in which ID starting from 1 to 8000 are put in the textbox in a LOOP and data retrieved is SAVED in some file(a text or database file)...
so is there any way?
check this out! you will see the textbox and the submit button! I need to get to all the result! i dunno may there or some other simple ways but what i am thinking is if we start submitting numbers from 1 to say 10000 and store the data we get in a file? is it possible? or if there is any simple way to get all the result?
its not some illegal stuff!
i just said if there is some other way and didn't mean like someone hack their database!
I gave my idea like to do iteration! just like if someone sits and start giving ID himself, submitting it and getting the info and thn saving it by himself,,,, there should be a way to do it in programming or scripting! which ll be fast....
i have to display huge data around 1,00,000 records.
My client requirement is not to use paging.
so i have to display this data in one time.
i dont how to display this.
cud we use crystal report for this???
The big problem with outsourcing is that the coders just blindly do what the client asks and never have the guts, or the knowledge, to tell the client that what they want is idiotic and technically not viable.
What the client wants is idiotic and technically not viable. Pages will time out before they send that much data, and users will never want to navigate it. They could export the data via a file download, and view it in Excel or something, but not in the page.
No longer a Microsoft MVP, but still happy to answer your questions.