Click here to Skip to main content
       

ASP.NET

 
QuestionCrystal report VS2010 doesn't render text position properly in asp.net page PinmemberSavun Cheam11-Oct-12 18:47 
Questionwhich one is better wsdl proxy or web reference Pinmemberindian14311-Oct-12 8:04 
AnswerRe: which one is better wsdl proxy or web reference Pinmembern.podbielski11-Oct-12 22:49 
AnswerRe: which one is better wsdl proxy or web reference PinprotectorAspDotNetDev12-Oct-12 10:27 
QuestionAutenticação Com FormsAuthentication - Não autentica!! PinmemberMember 939216811-Oct-12 6:10 
AnswerRe: Autenticação Com FormsAuthentication - Não autentica!! PinmemberWes Aday11-Oct-12 6:22 
AnswerRe: Autenticação Com FormsAuthentication - Não autentica!! - Translation PinmemberWes Aday11-Oct-12 6:24 
QuestionI am having error on my dbml (InternetTransaction Project) PinmemberDifameg Network Nigeria10-Oct-12 22:26 
AnswerRe: I am having error on my dbml (InternetTransaction Project) Pinmembern.podbielski11-Oct-12 0:04 
QuestionHaving trouble updating INT field in MS SQL 2008 database PinmemberMember 932884710-Oct-12 9:55 
AnswerRe: Having trouble updating INT field in MS SQL 2008 database Pinmembern.podbielski10-Oct-12 11:03 
AnswerRe: Having trouble updating INT field in MS SQL 2008 database Pinmemberemail_programmer_jim10-Oct-12 12:08 
AnswerRe: Having trouble updating INT field in MS SQL 2008 database PinmemberBernhard Hiller10-Oct-12 22:25 
AnswerRe: Having trouble updating INT field in MS SQL 2008 database PinmemberRichard Deeming15-Oct-12 3:31 
Member 9328847 wrote:
Dim sSql As XElement
sSql = <sql>
   Update [tblOncallAnalystSchedule] 
   SET [fldOnCallGroup] = '<%= fldOnCallGroup %>',
   ...
   </sql>
 
SendSQLCommand(sSql.Value, sqlConn)

 
Using an XElement to build your dynamic query won't prevent SQL injection[^]. You need to use a parameterized command instead.
 
Also, your code is trying to execute exactly the same query that's set for the UpdateCommand of the SqlDataSource control. If you remove the event handler, the control will perform the update for you.
 
Finally, the MsgBox calls will never work; if they did, the message box would appear on the server, where nobody would ever see them, and your page would be stuck waiting for someone to click "OK".



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


QuestionGoogle Analytics in site.master? Pinmemberjrahma10-Oct-12 7:36 
AnswerRe: Google Analytics in site.master? Pinmembern.podbielski10-Oct-12 11:00 
AnswerRe: Google Analytics in site.master? PinmemberSoyDesarrollador.net12-Oct-12 9:07 
QuestionAsp .net Video Player PinmemberShashankUpadhyay10-Oct-12 2:06 
AnswerRe: Asp .net Video Player PinmvpSandeep Mewara10-Oct-12 3:04 
QuestionLabel Text wrapping problem Ms chart control. PinmemberMurugan_vdm10-Oct-12 1:50 
AnswerRe: Label Text wrapping problem Ms chart control. PinmvpSandeep Mewara10-Oct-12 3:06 
QuestionSetting ASP.NET page controls from class library assembly PinmemberChesnokov Yuriy9-Oct-12 19:52 
QuestionRe: Setting ASP.NET page controls from class library assembly Pinmembern.podbielski10-Oct-12 3:38 
AnswerRe: Setting ASP.NET page controls from class library assembly PinmemberChesnokov Yuriy10-Oct-12 4:50 
GeneralRe: Setting ASP.NET page controls from class library assembly Pinmembern.podbielski10-Oct-12 10:59 
QuestionArchitecture suggestions for an application in Web and IPAD form Pinmemberkrishnapnv9-Oct-12 19:33 
AnswerRe: Architecture suggestions for an application in Web and IPAD form Pinmemberjohn-ph9-Oct-12 23:53 
AnswerRe: Architecture suggestions for an application in Web and IPAD form PinmemberPeter Carrasco11-Oct-12 16:31 
QuestionConnecting to IBM's natural language web service from vb.net Pinmemberindian1439-Oct-12 15:48 
AnswerRe: Connecting to IBM's natural language web service from vb.net Pinmemberjkirkerx9-Oct-12 17:25 
QuestionHi Friends i want to create a web application PinmemberVinothData9-Oct-12 15:41 
AnswerRe: Hi Friends i want to create a web application PinmemberVijaychauhan08069-Oct-12 19:18 
GeneralRe: Hi Friends i want to create a web application PinmemberVinothData11-Oct-12 19:37 
QuestionHow to set the x, y positions of the dynamic control PinmemberShashank Srivastava1)9-Oct-12 0:44 
AnswerRe: How to set the x, y positions of the dynamic control Pinmembern.podbielski9-Oct-12 0:59 
AnswerRe: How to set the x, y positions of the dynamic control Pinmemberjkirkerx9-Oct-12 11:20 
GeneralRe: How to set the x, y positions of the dynamic control PinmemberShashank Srivastava1)10-Oct-12 2:10 
GeneralRe: How to set the x, y positions of the dynamic control Pinmemberjkirkerx10-Oct-12 6:49 
GeneralRe: How to set the x, y positions of the dynamic control PinmemberShashank Srivastava1)10-Oct-12 2:19 
GeneralRe: How to set the x, y positions of the dynamic control Pinmemberjkirkerx10-Oct-12 7:01 
QuestionSorting a generic list of objects depending upon its one of objects property Pinmemberindian1438-Oct-12 21:32 
AnswerRe: Sorting a generic list of objects depending upon its one of objects property Pinmembern.podbielski8-Oct-12 21:52 
GeneralRe: Sorting a generic list of objects depending upon its one of objects property Pinmemberindian1438-Oct-12 21:58 
SuggestionRe: Sorting a generic list of objects depending upon its one of objects property Pinmembern.podbielski8-Oct-12 22:15 
Questiondoes form view shows only one record at a time? PinmemberUDTWS8-Oct-12 18:18 
AnswerRe: does form view shows only one record at a time? Pinmembern.podbielski8-Oct-12 23:36 
QuestionHow to make some part of textbox text to read only and other part to be editable Pinmembervinay_2898-Oct-12 7:25 
AnswerTextbox may not be the correct control PinmemberDavid Mujica8-Oct-12 8:32 
AnswerRe: How to make some part of textbox text to read only and other part to be editable PinprotectorAspDotNetDev8-Oct-12 11:51 
GeneralRe: How to make some part of textbox text to read only and other part to be editable Pinmembern.podbielski8-Oct-12 23:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 25 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid