VB.net and Stored Procedure
Eric,
It's possible to use Transactions with stored procedures. Depending on the
load (number of records), the other method I showed you is faster.
Look at SQLTransaction and SQLConnection object. You open a SQLConnection,
build a Transaction on that connection, use the transaction (and connection)
on the SQLCommand.
Quote:
> Is it possible to put stored procedure calls into thi Transaction Code
> option instead of Insert statements? These are some pretty large
> transactions so I am concerned with speed and reliablity. For example
> instead of building the "insert into statement" into the BeginTransaction
> and then doing an .ExecuteScaler. Can put the stored procedure there and
> then ExecureScaler for each stored procedure. If there is an error can i
> raise the error in the store procedure and roll back the transaction via
the
> vb code or do i roll back the transaction inside the stored procedure and
> fail out of the vb code?
> Eric
> > Hi Eric
> > you can use the ADO.NET Trasaction Option
> > http://msdn.microsoft.com/library/default.asp?
> > url=/library/en-
> > us/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassBe
> > ginTransactionTopic1.asp
> > HTH
> > Raj [MVP]
> > >-----Original Message-----
> > >Hello,
> > > I am pulling some items from a list view and putting
> > them into an array.
> > >I want to save those items to my database is is possible
> > to put all this
> > >information into one transaction in the stored procedure?
> > >Eric
> > >.
