|
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@
|
|
|
|
|
|
Really thankssss.. 
ALLAH bless you !
take care
regards,
SANA
$@N@
|
|
|
|
|
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.
|
|
|
|
|
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
take care
regards,
SANA
$@N@
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
Did you tried
<authorization>
<deny users="*" />
<allow users="mydomain\myuser" />
</authorization>
Regards
Sebastian
|
|
|
|
|
|
Just enable NT authentication for the application in IIS 
|
|
|
|
|
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 
modified on Wednesday, January 28, 2009 8:34 AM
|
|
|
|
|
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,
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
tomertro wrote: All the emails that i tried to send can be found on C:\Inetpub\mailroot\Queue.
Your SMTP server is not started. Start it and the mails will go.
|
|
|
|
|
Hi.
I have been given a legacy dot net 1.1 system to maintain. It uses bounds controls and templates. I am not allowed to scrap the techniques used.
I have to introduce another column after "Question [Yes]" which has an image and a text field with a click event. But it is only enabled (displayed), if the data value of "DataItem.YesQuestionID" = 0.
Anyone know how to do this please?
Many thanks.
-----------------------------------------------------------------------------------
<pre>
<TR>
<TD colSpan="2"><asp:datagrid id="grdQuestionnaire" runat="server" CssClass="labeltext" Width="100%" Font-Size="X-Small"
AutoGenerateColumns="False">
<Columns>
<asp:TemplateColumn HeaderText="Question">
<ItemTemplate>
<asp:Label id="lblQuestion" runat="server" ToolTip='<%# DataBinder.Eval(Container, "DataItem.QuestionText") %>'>
<%# DataBinder.Eval(Container, "DataItem.QuestionID") %>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Question [Yes]">
<ItemTemplate>
<asp:Label id="lblYesQuestion" runat="server" ToolTip='<%# DataBinder.Eval(Container, "DataItem.YesQuestionText") %>'>
<%# DataBinder.Eval(Container, "DataItem.YesQuestionID") %>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Question [No]">
<ItemTemplate>
<asp:Label id="lblNoQuestion" runat="server" ToolTip='<%# DataBinder.Eval(Container, "DataItem.NoQuestionText") %>'>
<%# DataBinder.Eval(Container, "DataItem.NoQuestionID") %>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:datagrid></TD>
</TR>
</pre>
-----------------------------------------------------------------------------------
<pre>
Private Sub LoadQuestionnaireDetails()
Dim QuestionnaireDS As Questionnaire = New Questionnaire
QuestionnaireDS = data.GetQuestionnaireDetails(cboQuestionnaire.SelectedValue)
grdQuestionnaire.DataSource = QuestionnaireDS
grdQuestionnaire.DataBind()
End Sub
</pre>
|
|
|
|
|
Which bit in particular are you having a problem with?
|
|
|
|
|
I need to be able to display new column, (with an image and some text), depending on the value of an existing column in the dataset. I get the feeling that I will have to trawl through the grid collection and test the necessary column value for each record. Am I on the right track?
|
|
|
|
|
Yes. You can check each row individually in the OnItemDataBound event and set the image visibility accordingly.
|
|
|
|
|
|
Hi all,
In my application i am using a Login Control and already there are some menus on it.But when i enter user name and password and press Enter key it doesn't go on to the login button.
Can any one tell how to do it??
Thanks in advance....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
