Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Professional
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 7th, 2007, 01:24 PM
Authorized User
 
Join Date: Dec 2006
Location: , , India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transaction Where Its Works More Efficiently

Hi programmer's,

Using Transactions in Windows application is more effective or using transaction in Web Application is More effective ?

Thanks in Advance

  #2 (permalink)  
Old March 12th, 2007, 05:39 PM
Friend of Wrox
 
Join Date: Jun 2004
Location: Chennai, Tamil Nadu, India.
Posts: 449
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to r_ganesh76
Default

The question is not clear.

are you talking about database transactions? Please make it clear

Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...
  #3 (permalink)  
Old March 13th, 2007, 11:48 AM
Authorized User
 
Join Date: Dec 2006
Location: , , India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Using Transaction In Windows Application Or In Web Application where it work more Efficiently, using C# For Windows/Web using Transaction Process In SQL
  #4 (permalink)  
Old March 13th, 2007, 04:52 PM
Friend of Wrox
 
Join Date: Jun 2004
Location: Chennai, Tamil Nadu, India.
Posts: 449
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to r_ganesh76
Default

SQL transaction works at the SQL Server side and not at the client side. Therefore it might not make a difference, whether it is being used in a web application or from a windows application.

This is same with most of the databases. If you are using SQL Server, use SqlClient namespace to access the database.

Regards
Ganesh
http://ganeshprof.blogspot.com
Find your solution here...
  #5 (permalink)  
Old March 14th, 2007, 02:39 AM
Authorized User
 
Join Date: Dec 2006
Location: , , India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ganash Thanks For Your Reply,

Ya I Did All The Thinks For Transaction, and i inserted data using SQL table my question not about how to use transaction, my doubt is about where that transaction can work effieciently in Windows Application Or In Web Application

  #6 (permalink)  
Old March 14th, 2007, 03:01 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

First of all, I don't understand the question. Or in fact, I don't understand how the answer can help you.

Transactions work best where they are needed. So, even if a transaction would perform 20 times faster in a desktop application (it doesn't), how would that benefit you when you're building a web application? What's the point in knowing where it performs better?

That said, I think that's what Ganesh said too. He didn't tell you how to use transaction but said:
Quote:
quote:Therefore it might not make a difference, whether it is being used in a web application or from a windows application.
Isn't that the answer to your question?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
  #7 (permalink)  
Old March 14th, 2007, 04:25 AM
Authorized User
 
Join Date: Dec 2006
Location: , , India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks For Your Reply Imar,

We Can Use Transaction In Windows Application And In Web Application too,My Doubt is Where it work more Effectively, You meantion that in Your Reply that Transaction Work 20 times faster in Windows Application,how about the Web Application, thats my doubt Imar,

Guide Me,

Thanks In Advance

  #8 (permalink)  
Old March 14th, 2007, 07:00 AM
Friend of Wrox
Points: 1,935, Level: 17
Points: 1,935, Level: 17 Points: 1,935, Level: 17 Points: 1,935, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2004
Location: United Kingdom
Posts: 550
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi windows_mss

Just try to focus on what Imar and r_ganesh76 are trying to explain, Imar just gave an example about 20 times faster in desktop application, he never confirmed it, read the post carefully.

For a basic understanding, there won't be any difference between web and desktop applications, as r_ganesh76 said, transactions are carried by SQL Server, so it won't consider whether you are requesting from a desktop or webapplication.

If you wanna use transactions in SQL Server, use the namespace SqlClient.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.
  #9 (permalink)  
Old March 14th, 2007, 02:14 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Yes, exactly. Couldn't agree with you more, Mike.

windows_mss: take a look at this:
Quote:
quote:even if a transaction would perform 20 times faster in a desktop application (it doesn't), how would that benefit you when you're building a web application?
This effectively says that a transaction in a web app isn't 20 times faster. But it also says that even if it *were* 20 times faster, it still wouldn't make a difference.

Who cares if transactions were 20 times faster in a desktop application when you are building a web application? IMO, you can't or shouldn't compare things like this....

Can you explain why you want to know the answer to this question? What does it matter to you?


Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
  #10 (permalink)  
Old March 14th, 2007, 11:45 PM
Authorized User
 
Join Date: Dec 2006
Location: , , India.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar,

The Reason For My Post is as follows,Desktop Applcation are mostly standalone or within a LAN Network, But when talk about Web Application it Use various network across the geographic area, we can use transaction in both the cases so only i got his Query


 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transaction/Reflection ffbalota C# 2 October 6th, 2007 04:54 PM
SQL Transaction k.manisha ASP.NET 1.0 and 1.1 Professional 2 January 24th, 2007 11:59 PM
How to export data to excel efficiently????????? avats ADO.NET 0 July 9th, 2005 01:09 PM
Efficiently Breaking Out of Parent AForgue XSLT 1 December 24th, 2003 11:52 AM
how to use Transaction ? locka ADO.NET 0 August 12th, 2003 08:48 PM



All times are GMT -4. The time now is 06:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.