Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

what is the problem with using SqlDataSource

Posted on 2009-04-29
5
Medium Priority
?
565 Views
Last Modified: 2012-05-06
my question is about SqlDataSource. is it ok to use SqlDataSource created by VS wizard? i heard that it is for hobby and not for a website that is published in the internet!!!.
is that not secure, why?
is the connection string appear in users page?
is there performance issue or limitation issue?
who is using SqlDataSource?
0
Comment
Question by:fahadman
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:maXXXeE
ID: 24259084
there are not many disadvantages in using SqlDataSource. It is not just for hobbyists. It can be used in live environment without any problems.
At times it when using Data Access Layer, you cannot use sqldatasource. And the hand coding with connection, command etc gives a lot of flexibility if you require it.
But if you can achieve what is required using sqldatasource, then it saves a lot of time and effort.
0
 
LVL 1

Author Comment

by:fahadman
ID: 24259230
is that not secure, why?
is the connection string appear in users page?
is there performance issue or limitation issue?
who is using SqlDataSource?
0
 
LVL 7

Accepted Solution

by:
maXXXeE earned 2000 total points
ID: 24259463
There are no major security issues.
The connectionstring wont apper in the browser. You can check for urself if you want. Just create an aspx page place  a sqldatasource in it. run it in the browser and check the page source.
There is no considerable performance issues with datasource.

Almost all asp.net applications use sqldatasources, unless data tier like Data Access Layer is used.
Is there any specific reason why you are hesitant to use sqldatasource?
0
 
LVL 1

Author Comment

by:fahadman
ID: 24259724
thanks maxxxee for great response,
i know this is additional question.
 my friend is using mygeneration doodads, so when he want to add new record to database he uses addnew(), but when using gridview or dropdown list he adds sqldatasource. for me this is mixing between 2-tier and 3-tier, am i right?
0
 
LVL 1

Author Comment

by:fahadman
ID: 24259889
please fin this question in another post
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question