|
I have a multiline textbox on my webpage. I make a stored procedure call to save the textbox value to a database. If I enter in for example "test'ing" with single quote, the app errors. How to handle this? Is there an escape sequence for this?
|
|
|
|
|
You need to escape such strings, so replace ' with ''. That is 'test'ing' becomes 'test''ing'.
Cheers,
Karthik
|
|
|
|
|
Use SqlParameters.
Check this http://www.codeproject.com/KB/database/NET_Data_Access.aspx
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
I download Ajax toolkit. next,create a tob in VS2008 toolbax called Ajax toolkit. then I add this file AjaxControlToolkit.dll
the problem is after adding the dll I can't see anything regarding Ajax Control.
does anyone know what the problem could be?
I have VS2008 and download Ajax control toolkit .Net35
|
|
|
|
|
future3839 wrote: I download Ajax toolkit. next,create a tob in VS2008 toolbax called Ajax toolkit. then I add this file AjaxControlToolkit.dll
the problem is after adding the dll I can't see anything regarding Ajax Control.
Where did you add the ddl ?
Right Click on Toolbox > Choose Items... > Then select the dll !
Hope this helps.
Thanks !
|
|
|
|
|
thx for ur reply. Actually, I did the same way but got same problem.after adding dll nothing add to my Tab
|
|
|
|
|
Also, Can have a look to a very good explain, which explains step by step process to install Ajaxtoolkit in VS 2008.
Click here
|
|
|
|
|
Hello,
Firstly, I am sorry if I write my topic in wrong section cause I couldn't find right topic for it. I just start studying Ajax and using it in my ASP.Net web application. in one article I read this one:
<br />
Ajax is for Action Not Content<br />
<br />
If you're going to put up an Ajax application, or just something Ajax-like on your Web site, first determine if the data you're accessing changes. The point of the asynchronous request is that it makes requests to the server for information that has changed faster - because it's happening while the reader is doing something else. Then when they click a link or button (or after a set amount of time - whatever your distinction is) the data shows up right away.<br />
<br />
If your content or data never changes, then you shouldn't use Ajax to access it.<br />
<br />
If your content or data only rarely changes, then you probably shouldn't use Ajax to access it.<br />
the above sentence is from this http://webdesign.about.com/od/ajax/a/aa092506.htm
in this case, I should use Ajax in my website, when I wanna interact with data? is that true? for instance, like CMS projects or if I have more job with database then using Ajax might help to improve the performance of my database. is that true?
iate
I appreciate if you guys tell me your suggestions.
|
|
|
|
|
future3839 wrote: I have more job with database then using Ajax might help to improve the performance of my database.
Ajax doesn't improve the performance of database.
If you understand Ajax properly, you yourself will be in a position to decide whether to use it in your
scenario or not.
For simple CMS project, where contents are static and just for display purpose, I would suggest not to use Ajax.
Different people have different thoughts.
|
|
|
|
|
|
I would like to implement a very simple progress indicator, a '18%' style thing. How do I do this? I have a long running import process that updates a session variable with its progress every few iterations. I have client side code that periodiclally calls a static Page Method to retrieve the progress, but Firebug indicates the POST for this call is aborted, with no error message. Do I have to access the session variable from another page where the import process is not running, or vice versa rather, move the import process to the code hood of the project tree and keep the page for page things, like requesting and repporting import prpgress?
|
|
|
|
|
A few months ago I set up a website for a minister friend of my mine. For the secure section of the website I used the standard login.aspx page with the Microsoft Login Control.
The site was published to a third party host so the user login info is stored on the remote SQL Server database. Everything has performed fine for about 8 months until yesterday. He calls me and says that he can't log in! I wasn't worried and told him I would fix it today. Now I am worried! Every attempt to login or reset the password had been unsuccessful! 
I've been doing research and it appears that the LoginControl has several bugs.
Here's the main question: Is there any way I can reset the user passwords using another tool? I can log into the remote server using SQL Server Management Studio.
Thanks,
Mr. Depressed
|
|
|
|
|
|
I have a label(100px) with text that could include more than one word, when it happens the label adds line breaks between the words, how can I avoid it?
|
|
|
|
|
benams wrote: when it happens the label adds line breaks between the words
It is not like this.
When your two words exceeds with the specified width, it will move in second line. Thats what it is happening.
|
|
|
|
|
Add a NOWRAP attribute. Or wrap it in a NOBR tag.
|
|
|
|
|
Hi,
How can I prevent catch on my entire application?
|
|
|
|
|
|
You need to give more detail about your question.
Are we talking about data caching? To the database ?
Or are we talking about page caching? Like .aspx pages ?
Under most circumstances, caching is a good thing, not a bad thing.
|
|
|
|
|
yeah sorry it's my mistake
i mean the page catching
|
|
|
|
|
Still not helpful. Page Catching??? Do you mean Page Caching perhaps?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Just add the following lines of code in code behind:
Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Cache.SetNoStore()
If you want no caching for whole website, add it in code behind of Master Page.
|
|
|
|
|
Hi,
Anyone knows a free ASP.NET support ticketing application which I can use for my website so I can embed into my website just like smarterTrack?
|
|
|
|
|
|
Hi,
I have an 64 bit .net application loaded in IIS7 with OS 2008.
When the server is restarted the application is working fine for 2-3 hours and after that it going to slow vigorously.
I checked all the network settings and it’s fine…. Can any one help me
Joydeep Das
das.joydeep2@gmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Green Alien | [Alien]](https://www.codeproject.com/script/Forums/Images/alien.gif)
Indian CodeProject Members Meet 2010 - Nominate Now 