Avatar of ALawrence007
ALawrence007 asked on

SQL Transaction insert

Hi,
I have a SQL based web application. The application requires about 50 textbox inputs. I created the application using a transaction for insert and if all is O.K. then a commit statement.

My question: Will this give me any issues when I place this on my intranet? Will the table be non usable?
Are there any suggestions if this is not the right way to go?

The reason I went this way is to prevent multiple non usable entries into my Master table if there are any issues.

Thanks
ASP.NETVisual Basic.NETMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Aneesh

8/22/2022 - Mon
SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
matrix_aash

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
ALawrence007

Thank you! All answers to my question.

This is my current set up:
insert1="inert into table1 (field1) values('ss')"
cmd.ExecuteNonQuery();
insert2="inert into table1 (field1) values('ss')"
cmd.ExecuteNonQuery();
insert3="inert into table1 (field1) values('ss')"
cmd.ExecuteNonQuery();
Aneesh

>This is my current set up:
in this case, you can probably create an XML at the front end and pass it to the back end; in the back end you can fetch the data fron the xml and insert into the table.  in this way you can reduce the transaction length.
Rejojohny

>> in this way you can reduce the transaction length.
actually, if you plan to take this approach, you will not need a transaction ..
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Aneesh

yup, correct