|
abglorie wrote: Dim mystring as string = "Women's Studies"
Replcae "'" to "`" and insert into database.
At retriving from database, Replace "`" into "'"
for example
Dim mystring as string = "Women's Studies"
mystring =mystring.replace("'","`");
MySql = "INSERT into tblName (Dept) values ('" & mystring & "')"
.......
please don't forget to vote on the post that helped you.
|
|
|
|
|
if you use parameterised queries it solves both a) The apostrophe problem and b) the sql injection vulnerability problem.
|
|
|
|
|
is it possible not to show the context menu dilog box on the address bar.
|
|
|
|
|
Hi,
I am using an asp:FileUpload control with a regular expression control to check the file types. The regular expression has a error message if it is a file with a different extension.
On the page is an upload button. When the upload button is clicked, and the file extension is correct, then it uploads the image to the server. But the page does a post back to itself and the error message of the regular expression validator is fired. Why is this and how can I prevent it from being fired after the file is uploaded?
Brendan
|
|
|
|
|
As per my understanding:
use this property of Reg validator
enableclientscript="True"
If I am wrong, please correct me
/***********************/
Parwej Ahamad
g.parwez@gmail.com
/***********************/
|
|
|
|
|
Read the message again. When I click on the upload button it then uploads the image to the server and in the process does a post back. But once the page did a post pack the regular expression validator control is triggered some how and the error message is displayed. I don't want the message to be displayed after postback, it's not even supposed to display after postback.
|
|
|
|
|
After save the file set validator property
IsValid with true
/***********************/
Parwej Ahamad
g.parwez@gmail.com
/***********************/
|
|
|
|
|
hai all,
i have two webforms named "first" and "second".
i want to get a value from "second" page to "first".
Once the user press an button in "second"(link) page the textbox value from "second" page should set to an textbox of "first" page which is master page.
help me plz.... its urgent my friends.
Currently i m using ASP.NET with C# (.net 2003, 1.1 framework)
- John
modified on Monday, February 18, 2008 11:09 PM
|
|
|
|
|
John Sundar wrote: .... its urgent my friends.
Of course - they're ALL urgent, and yet, no-one knows how to use google, it seems.
I recommend you buy a beginners book on ASP.NET or just web development in general, so you get some basic concepts under your belt. One very basic concept is that the two ways to store values between pages, are to store them in your session, or ( better here ) put them on the URL.
When you redirect to second.aspx, if you redirect to second.aspx?id=5&name=fred, you can use the Request.QueryString class to access the values of 5 and fred, via their names, id and name. Of course, your users can see this on the URL, so don't use it for sensitive data.
John Sundar wrote: Currently i m using ASP.NET with C# (.net 2003, 1.1 framework)
Why are you using a framework that is four years and two iterations out of date ? VS2005 and VS2008 would allow a cross page postback, a third option for passing data between pages.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: Why are you using a framework that is four years and two iterations out of date ?
Oh My! You can not expect that much up-to-date attitude here. I had an opportunity to talk with one of my colleague who was with me in one of my second previous organization. They are still using VB/ASP and Crystal Reports.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Some people are locked into legacy projects, but this guy is obviously very much a beginner, so I assume he's just learning, and the express editions are free, so there's no reason to learn 2003 that I can see.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: so there's no reason to learn 2003 that I can see
I have a good reason (I think)
To keep my tools up-to-date all the time, I will spend time searching and downloading new versions, or I will lose my money purchasing these updates
And the biggest problem is that I will waste time learning how to use the new tool or versions
So when will I develope?
I think that I can do everything using C++ or even ASSEMBLY
Mohamed Gouda
Egypt
|
|
|
|
|
Generally speaking when people sell tools they price them so they are worth buying... its worth trying out things that you have heard good things about - it saves you money over the longer term. (ie: Resharpers saved me many times it's list price in time).
|
|
|
|
|
Mohammed Gouda wrote: or I will lose my money purchasing these updates
Well, the express editions are free so you won't lose money there.
Mohammed Gouda wrote: And the biggest problem is that I will waste time learning how to use the new tool or versions
In general, the new versions build on the older ones so your knowledge won't go to waste. More importantly, the versions tend to introduce improvements and productivity enhancers so you should have a look.
|
|
|
|
|
I highly recommend the latest Visual Web Developer 2008. Its free obviously and has alot of great features that save you time writing code.
|
|
|
|
|
Hi,
I want to read and write the records from the databse(Client side)
and then these records get inserted into the table that is at server side.
I want to create script or any file format(Excel,XML) so that server database can read and then write the records into the server table.
format and records will remain same.
How Can I do this?
Thanks
sjs4u
|
|
|
|
|
ASP.NET can't read data from client database since ASP.NET executes at the server. You can use DTS to transfer data from one server to other, but it has nothing to do with ASP.NET. SQL forum would be appropriate.
|
|
|
|
|
Ok.
Will it possible to write structure of client database and then use
it at the server.
and then by using the ASP.Net Program it can be read and then write at the server side.
or some any solution for this problem.
Thanks
sjs4u
|
|
|
|
|
you can write a component that embeds in a webpage, but even then, I doubt it can read the client side DB. Even if it had a valid connection string. Really, your best bet is to provide a client side application that takes the connection string, reads the database, and sends the data via a webservice. ASP.NET isn't going to cut it.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thanks For the Information.
But again it is possible to read and write database structure(also contains records) and run it at the client side using the ASP.Net Application.
If yes then How can it be?
Thanks,
sjs4u
|
|
|
|
|
I'm speechless.
Yes, you can do it, easily. That's why two people have told you it can't be done, we're trying to keep all the good stuff for ourselves.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I have to read the records and the write it into the XML or Excel file.
Then with the Help of the above file I want to fetch the records and stored it into the database. I dont want to write directly to the database.
The Records writes in a such a way that structure of the database would not change.
How can it be possible.
Thanks,
sjs4u
|
|
|
|
|
Please don't ask if you're going to ignore the answers you're given.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
sjs4u wrote: Will it possible to write structure of client database and then use
it at the server.
and then by using the ASP.Net Program it can be read and then write at the server side.
You can't automate this process. You can take the structure of database manually, supply that through an upload control to ASP.NET and execute it on the server. ASP.NET can't read the file you created at client side automatically. But don't go for such kind of solutions since it's not the right way to do this.
If you are trying transfer data from client DB to server DB, DTS will do a fair job.
|
|
|
|
|
After successfully saving the information into the database , how should i invoke the message box with a button ok and a caption , record is successfully saved.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
