Arg81
Well-known member
Simple question really,
I haven't yet looked into SP's, instead I'm using dataAdapters on my forms, created at designtime, not runtime.
I'm now looking at transferring a lot of my form selections to SP's - basically on most of my forms I have a dataAdapter for my parent table, and then dataAdapters for each child table - with a Stored Proc I assume I can call the whole lot in one go.
What's the best way of calling a Stored Proc? Implementing it at run-time within my code form_load, or creating a dataAdapter to connect to it?
Help much appriciated,
Luke
I haven't yet looked into SP's, instead I'm using dataAdapters on my forms, created at designtime, not runtime.
I'm now looking at transferring a lot of my form selections to SP's - basically on most of my forms I have a dataAdapter for my parent table, and then dataAdapters for each child table - with a Stored Proc I assume I can call the whole lot in one go.
What's the best way of calling a Stored Proc? Implementing it at run-time within my code form_load, or creating a dataAdapter to connect to it?
Help much appriciated,
Luke
