data inserting problem into sql having single quote in it through asp form - ASP.NET Discussion Boards

Re: ASP.NET Session State

Socheat.Net28-Jan-09 15:52

Socheat.Net

28-Jan-09 15:52

Thanks.
I will try my best

Socheat

Re: ASP.NET Session State

Abhijit Jana28-Jan-09 16:02

Abhijit Jana

28-Jan-09 16:02

You can do one thing. Create a separate Application Pool For Your Web Application Only. Then test the web application. Make sure you are having only one Worker process (Not a web garden).

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Displaying entire on contents of multiline textbox

krup7528-Jan-09 13:05

krup75

28-Jan-09 13:05

My questions is that I want to expand out a multiline textbox that could have anywhere from 1 to 100 lines of data so it will all show up when I print it? I have been trying for days and have had no luck, so any help would be great.

Thanks

Re: Displaying entire on contents of multiline textbox

N a v a n e e t h28-Jan-09 14:42

N a v a n e e t h

28-Jan-09 14:42

What do you mean by expanding the multiline textbox? Are you trying to print the entire contents on the screen? If yes, you need to replace newline characters with <br> and \t with &nbsp to get the text in correct format.

Navaneeth

How to use google | Ask smart questions

Re: Displaying entire on contents of multiline textbox

krup7528-Jan-09 15:01

krup75

28-Jan-09 15:01

I have a form that user is filling out, drop down boxes, radial buttons, text buttons and multiline text buttons. When user enters the data in the mutiline textbox and it scrolls down. I want to print the page in the same layout as the data was entered, but with the multiline textbox expanded out so when it printed out, all the data would be displayed like it was on the page from all the fields and from the multiline textbox would so everything.

Thanks for the reply

Re: Displaying entire on contents of multiline textbox

N a v a n e e t h28-Jan-09 15:12

N a v a n e e t h

28-Jan-09 15:12

Follow what I said in my previous reply. Just do the replace.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: Displaying entire on contents of multiline textbox

krup7528-Jan-09 15:55

krup75

28-Jan-09 15:55

That will autoexpand and auto-contract the size of my textbox depending on the number of lines of text?

data inserting problem into sql having single quote in it through asp form

sana1728-Jan-09 10:18

sana17

28-Jan-09 10:18

Asalamoalekum All,

i am working with ASP.NET... i have a from with textbox and a button
when user press button the text of textbox is inserted into a sql table

the insert query behind button is:

string insert = "insert into myDB.dbo.Messages (text) values('"+textbox1.text+"')";

IF MY TEXTBOX CONTAINS COMBINATION OF ANY CHARACTERS (except single quote as aspostophe) there is no problem, it works properly but IF MY TEXTBOX contains any single quote.. for Example:
textbox1 text is :- its HER'S matter dont disturb her

here it encounters an exception that unclosed single quotation...

how i could avoid this... because single quote is very common, user needs to use thisss!

(if single double quotation mark(") is used there is no problem)

please tell me the solution.

thanks,
regards,
SANA AHMAD

$@N@

Re: data inserting problem into sql having single quote in it through asp form

ToddHileHoffer28-Jan-09 10:38

ToddHileHoffer

28-Jan-09 10:38

Start here
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson06.aspx[^]

after this get yourself a beginner's book on asp.net and databases and read up.

I didn't get any requirements for the signature

Re: data inserting problem into sql having single quote in it through asp form

sana1728-Jan-09 22:07

sana17

28-Jan-09 22:07

Really thankssss.. Smile | :)

ALLAH bless you !
take care
regards,
SANA

$@N@

Re: data inserting problem into sql having single quote in it through asp form

N a v a n e e t h28-Jan-09 14:44

N a v a n e e t h

28-Jan-09 14:44

sana17 wrote:
how i could avoid this... because single quote is very common, user needs to use thisss!

By using parameterized queries. Read about SQL Injection attacks[^], a best article on the subject, and rewrite your query.

Navaneeth

How to use google | Ask smart questions

Re: data inserting problem into sql having single quote in it through asp form

sana1728-Jan-09 22:06

sana17

28-Jan-09 22:06

THANKSSSS ALOT.. its really good article...
i have never thought the probelm in this way... really its cool and logical!!

THANKS AGAIN!
ALLAH bless you Smile | :)

take care

regards,
SANA

$@N@

Circula Button

ziwez028-Jan-09 7:10

ziwez0

28-Jan-09 7:10

Hey,

I have to provide one of my clients a visio app, but in the form of a web app.
I havent looked around, hence starting here, but basically I dont need anything to fancy.
Im not sure if a solution exsists already? but I have a meeting tomoz and have highlighted
some pre requirements.

Now the client wants me to do all these wonderful diagrams for him, but Im 99.9% sure he would
be more happy with having the tools so they can do it in house.
So I want to provide them some basic tools to be able to produce this.

So 2 things here, 1 is to allow the user to design the diagram and the 2 it to present it to the
user users, so they will see a presentation

1. Circula Button - Text in the middle, a standard size, 3 colour types,
- This is needed as user will be able to click the button and bring up another web page that will contain data.

2. Pointing arrors - to be able to point\ link lines between the Circula Buttons.

Right,

1. Does a solution like this already exist?
2. IF 1 = False, how do I go about creating a button to use in a web app, advice, example, links?

thanking you in advance

asp.net ajax accordion recursive method

kuyucakli28-Jan-09 6:30

kuyucakli

28-Jan-09 6:30

hi friends. i want make a recursive method for fill all categories and subcategories to a asp.net ajax accordion.

so i need like this:

Computers
--Notebook
---AMD
----Intel
-----Intel Core Duo
-------Intel ABC PC
-------Intel XYZ PC
-----Intel Core 2 Duo
--Desktop PC
---PC1
---PC2
Mobiles
--With Camera
---Good Phone
---Bad Phone
--Without Camera
--Pocket PC

how I to do bind or fill this structure to Ajax accordion?

viva la commune

multi thread in web service

raquidd2228-Jan-09 4:49

raquidd22

28-Jan-09 4:49

hello

i wish manage a budget in my company
i make a web service

'this variable is global
Shared saldo As Integer
<webmethod()> Public Function ExisteSaldoSMS() As Boolean

'get saldo

If saldo > 0 Then
'is saldo
saldo -= 1
update saldo
existeSaldo = True

Else
'No saldo
existeSaldo = False

End If

Return existeSaldo

End Function

i have a test aplication
firs i run the application with a loop 50 next i go to my database in the saldo is correct

but if i run 2 thread one with 50 request and the other with 100 my saldo no is correct

i have the variable shared saldo

Can someone help me how is the way correct to work saldo to multi thread

Thanks for the time
regards

Re: multi thread in web service

Colin Angus Mackay28-Jan-09 14:46

Colin Angus Mackay

28-Jan-09 14:46

If "saldo" is being updated in multiple threads then you must protect it. Concurrency is a big topic and there are many access patterns that depend on what your intended use is.

However, there are some things you might want to ask yourself first:

Must "saldo" be shared? What is the purpose of sharing "saldo"? Is it publically accessible, or only private? What are all the situations it is used in? Is it just the updates that need protecting, or is it a number of statements around the use of "saldo" that need protecting?

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

How to allow a user and deny all others

Le centriste28-Jan-09 4:11

Le centriste

28-Jan-09 4:11

I have a problem where I have to give permission to one user and deny all others. I authentication mode is Windows and the authorization node is like the following:

<authorization>
    <allow users="mydomain\myuser" />
</authorization>

This lets pass all users, probably because of the absence of a deny rule. So I modified it:

<authorization>
    <allow users="mydomain\myuser" />
    <deny users="*" />
</authorization>

Now, no user, including mydomain\myuser, can access the app. I tried:

<authorization>
    <allow users="mydomain\myuser" />
    <deny users="mydomain\otheruser" />
</authorization>

Both users can access the app.

I even tried reversing the order of the allow and deny nodes, to no avail.

Anyone has any idea on how I could fix this problem?

NOTE: I CANNOT USE ROLES. This is because we are a large organization and they won't create Windows groups just for this app.

Re: How to allow a user and deny all others

SeMartens28-Jan-09 4:39

SeMartens

28-Jan-09 4:39

Did you tried

<authorization>
    <deny users="*" />
    <allow users="mydomain\myuser" />
</authorization>

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: How to allow a user and deny all others

Le centriste28-Jan-09 4:47

Le centriste

28-Jan-09 4:47

It does not work either.

SOLVED

Le centriste28-Jan-09 4:52

Le centriste

28-Jan-09 4:52

Just enable NT authentication for the application in IIS D'Oh! | :doh:

ASP.Net Development Server Issues [modified]

Jacquers28-Jan-09 2:26

Jacquers

28-Jan-09 2:26

I'm having some issues with the ASP.Net development Server:

VS tells me that it could not launch it because the port I specified is in use (I've set it to use a static port number). However, if I use netstat it doesn't show that any program is using the port. I do run nod32 AV but I don't think this is an issue as I can start the webdev server without a problem from the command line specifying the port that is apparently "in use" and can then browse to the address in IE.

UPDATE:

It was NOD32. What a PITA! Very weird considering I could start the webdev server from the command line and browse the site from IE without issues and that this issue happened today after running NOD32 for months! It must have been an update on their side that broke things Mad | :mad:

modified on Wednesday, January 28, 2009 8:34 AM

Build Error

ais0728-Jan-09 2:13

ais07

28-Jan-09 2:13

Hi There,
I have a class library where if I make any syntax error purposely and when I build the project it shows me message as Build Succeeded.Because of this I am not able to identify errors in my project.If antbody knows please help.

Thanks,

Re: Build Error

mr_muskurahat28-Jan-09 3:52

mr_muskurahat

28-Jan-09 3:52

there must be exception in your dll if you do syntax mistake then compiler wont allow you to build it...

so only in case of exceptions it give message built succeded...

umerumerumer

calling remote webservices from sharepoint using javascript

gottimukkala28-Jan-09 0:47

gottimukkala

28-Jan-09 0:47

Hi

I am trying to invite my remote webservices using Javascript from sharepoint with the follwoing code: but everytime I get Access is denied error.

httpReq.open('post',url, true);
httpreq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
httpreq.setRequestHeader("SOAPAction","http://schemas.microsoft.com/sharepoint/dsp/queryRequest");
postparams = "method=GetStructureWithPublications&structureId="+StructureId+"&language="+Language;
httpreq.onreadystatechange = function()
{
var done = 4, ok = 200;
if (request.readyState == done && request.status == ok)
{
if (request.responseText)
{
vtaTree.GetDataCallBack(request.responseText);
}
else
{
vtaTree.GetDataCallBack(request.responseXML);
}
}

};

httpreq.setRequestHeader("Content-Length",postparams.length);
httpreq.send(postparams);

Any one please help me.

email not getting to destination address

tomertro28-Jan-09 0:27

tomertro

28-Jan-09 0:27

Hi
The following code send an email using Net.Mail.MailMessage.

The code run fine with no exceptions but the email not recive in the destination address.

The application run on IIS v 5, os: xp.
email send by virtual SMTP server

All the emails that i tried to send can be found on C:\Inetpub\mailroot\Queue.

here is the code :

public class Email

{

private string _To;

private string _Subject;

private MailMessage email;

public Email(string To, string Subject)

{

_To = To;

_Subject = Subject;

}

private void SendHtml(string msg)

{

email = new MailMessage("tomer_t@TOMER-7VGO1O5DD", _To);

email.IsBodyHtml = true;

email.Body = msg;

email.Subject = _Subject;

SmtpClient smtp = new SmtpClient("TOMER-7VGO1O5DD");

smtp.Send(email);

}

public void Contact_Us(string FirstName, string LastName, string Phone, string Bagrut, string Path)

{

StreamReader SR = File.OpenText(Path + "\\Templets\\Contact.htm");// new StreamReader(Path + "\\Templets\\Contact.htm");

string msg = SR.ReadToEnd();

SR.Close();

SendHtml(msg);

}

}

Please advice.

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