WarrenAyen
08-01-2006, 01:55 PM
Hello All,
I work for IBM, designing web applications. I'm quite new to it, learning it all on the fly. My previous experience is in Visual Basic and Visual C#, using DAO to access SQL Servers and Microsoft Access. I'm very, very good at it, but current technology is moving away from that method of data access...well, it already has.
Right now my current focus is using ADO.NET in ASP.NET in VB 2003. I've gotten quite good at it, but I don't data-bound. In fact, I do most of the data handling directly in code. I create my Select/Insert/Update/Delete commands, my data adapters, datasets, and datatables at run-time rather than using the wizard. I do this mainly to learn the underlying mechanics, but I've found it gives me far more flexibility than using wizards. However, I can't find a fix for my issue in code or a wizard:
My current WebForm is designed soley as a data entry form - our clients enter their request to have the File Transfer Team set up a transmission for them to submit financial data securely. What I do is this:
'create the empty dataset
Me.MP_TBLREQUESTSMASTER = New DataSet
'fill the dataset
Me.FTT_ADAPTER.Fill(Me.MP_TBLREQUESTSMASTER)
'create the datatable from the dataset
Me.tblRequestsMaster = Me.MP_TBLREQUESTSMASTER.Tables("MP_TBLREQUESTSMASTER")
The issue is the "FTT.ADAPTER.Fill" method. Right now there is only a few test records, but eventually we expect to have 500,000+. Each time the form posts it will have to load that data just so someone can enter in a new request. No one is actually ever accessing the data themselves (we will on our own using a faster Windows-based client that connects to the database). By the way, the database is in Oracle 10, so this is all done with the System.Data.OracleClient reference.
Thus my question is this: How do I open up the table or dataset directly for editing, without filling it? I've tried skipping the fill command, and got an error message (the webform traps errors, I removed that code for readability). Can I access the table directly without filling it and without using a dataset?
Thank you, anyone that responds :)
Warren Ayen
I work for IBM, designing web applications. I'm quite new to it, learning it all on the fly. My previous experience is in Visual Basic and Visual C#, using DAO to access SQL Servers and Microsoft Access. I'm very, very good at it, but current technology is moving away from that method of data access...well, it already has.
Right now my current focus is using ADO.NET in ASP.NET in VB 2003. I've gotten quite good at it, but I don't data-bound. In fact, I do most of the data handling directly in code. I create my Select/Insert/Update/Delete commands, my data adapters, datasets, and datatables at run-time rather than using the wizard. I do this mainly to learn the underlying mechanics, but I've found it gives me far more flexibility than using wizards. However, I can't find a fix for my issue in code or a wizard:
My current WebForm is designed soley as a data entry form - our clients enter their request to have the File Transfer Team set up a transmission for them to submit financial data securely. What I do is this:
'create the empty dataset
Me.MP_TBLREQUESTSMASTER = New DataSet
'fill the dataset
Me.FTT_ADAPTER.Fill(Me.MP_TBLREQUESTSMASTER)
'create the datatable from the dataset
Me.tblRequestsMaster = Me.MP_TBLREQUESTSMASTER.Tables("MP_TBLREQUESTSMASTER")
The issue is the "FTT.ADAPTER.Fill" method. Right now there is only a few test records, but eventually we expect to have 500,000+. Each time the form posts it will have to load that data just so someone can enter in a new request. No one is actually ever accessing the data themselves (we will on our own using a faster Windows-based client that connects to the database). By the way, the database is in Oracle 10, so this is all done with the System.Data.OracleClient reference.
Thus my question is this: How do I open up the table or dataset directly for editing, without filling it? I've tried skipping the fill command, and got an error message (the webform traps errors, I removed that code for readability). Can I access the table directly without filling it and without using a dataset?
Thank you, anyone that responds :)
Warren Ayen