The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Trying new things all the time
Posted: 25 Sep 06 2:32 PM
|
fiogf49gjkf0d I am trying to learn new things all the time, now I am working with VS2005 and trying to use DataSets and Data tables vs using recordsets. This way I can make my applications run a little faster specially updates etc..
I am able to open the connection to the SLX database through the provider however I can't seem to get my dataset to fill
The code I am trying to emulate is using a system SQl connection and I am trying to change the connection to the provider connection. Is this even possible ? or am I restricted to using a recordset...? If so does anyone have a snippet of the fill process for a dataset, or table. through the provider..?
Thanks in advance
 |
|
|
|
Re: Trying new things all the time
Posted: 26 Sep 06 10:37 AM
|
fiogf49gjkf0d What does the code look like so we can see what might be wrong?
BTW, forget about Recordsets. To me it makes no sense to make the move to .NET and hang on to old-skool ADO. |
|
|
| |
|
Re: Trying new things all the time
Posted: 27 Sep 06 4:43 PM
|
fiogf49gjkf0d
Ryan's SLX Login screen code helped me out plenty. It doesn't include heavy stuff like DataAdapter.Fill but it was a good base for me to get started with code I knew actually worked. I'm better at learning through example so I can take Ryan's example, frankenstein it and come up with something usable. The concepts, layout, and a good bit of code is retained but eventually it morphs into something almost entirely mine. I could have taken the time to do it all from scratch but I consider that a waste of time since I usually test just about every property adjustment visually rather than take documentation's word on it's behavior. I'm anal like that but it makes sure that no quirks I haven't thought of are introduced that I have to troubleshoot or workaround later. |
|
|
|
Re: Trying new things all the time
Posted: 28 Sep 06 1:31 PM
|
fiogf49gjkf0d Ryan, Thanks again was what I was looking for.. I'm looking at going back and taking the scripts I currently have that update tabels and such from external sources and redo them using datasets and tables so I can increase the speed of these scripts.
Look forward to meeting you in Nashville
Rich |
|
|
|