|
 I have a text box. Data enered in this textbox is inserted into a database table. How can I enter single quote (eg: Peter's) in this text box and insert the same into the database (ASP .Net, C#)?
|
|
|
|
|
Use Parameterized queries. Your insert query would be
INSERT INTO MyTable(MyColumn1,MyColumn1) VALUES(@MyFirstParam,@MySecondParam) . You need to supply these parameters in your command object like
MyCommand.Parameters.Add(@MyFirstParam,value);
MyCommand.Parameters.Add(@MySecondParam,value);
|
|
|
|
|
You might also want to have a look through your code and have a think what the results of me entering
foo'; DROP DATABASE; --
into your textbox.
Have a google for SQL injection.
|
|
|
|
|
i have a lookup in sharepoint and it fill with number for example the content of that is 1 2 3 4 5 ...
now i want it contains sometime 1 sometime 2 and ..
i want filter it.
can i do this in sharepoint designer with javascript and how?
|
|
|
|
|
Does anyone know an easy way to consolidate mutilple stylesheets into one global sheet that contains all common style settings and a number of specific sheets that can then be applied to the relevant pages.
My situation is that we had an external designer provide templates that differ only in colour for branding various sections of the site.
The problem is that they have written large CSS's that have many common elements and a few specific settings that either point at a small graphic file or have a couple of colour settings different. (There are about 700 lines per sheet).
I would like to convert these to something like
Global.css
Red.css
Green.css
Yellow.css
...
and just apply the global.css and red.css to the red pages, Global.css and Green.css to the green pages, etc.
I have done a google search and CP search and can't find any thing that looks like it will help.
|
|
|
|
|
Hi to all,
I created wrapper for the activex control created in vb
by aximp
i run aximp socx.ocx
socx is the name of my active x control.
Then i got two dll AXSOCXLIb and SOCXLib
i added to my .net 2003 reference folder then
i create object
Public X1 As New SOCXLib.SOCXClass
and pass all parameter to one of the method that is
str = gOutgoingNo & Trim(txtDialNo.Text)
g_NewCallRefID = 0
ip_addr = "130.1.12.21"
extn = 3308
X1.SCTMakeCall(str, "", g_NewCallRefID)
i got all the parameter but on last statment
when he call SCTMakeCall method i got
System.Runtime.InteropServices.COMException: Catastrophic failure
This is very urgent
please help me
Regards
Sonia.
|
|
|
|
|
soniasan wrote: This is very urgent
In case you haven't noticed, no one is really going to care. It is frowned up around here to tell people your problem is urgent.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
I have set a JPEG image as BackImageUrl of a table in design time.But it fails to display as page loads.
What will be the reason behind this pls give me an idea.
|
|
|
|
|
georgegarvasis wrote: But it fails to display as page loads.
Maybe the picture is large and hasn't yet loaded itself?
|
|
|
|
|
Hello everyone,
I have successfully made a Jar executable file from a Java program, by changing the manifest. But for some reason, it executes perfect on my computer, but will not run on any other computer. It says "can;t find main class". I run JRE 6 and my friends run the jre 5. could that be it? any help is very appricated.
Thank you.
Drozes
- Droz -
___ ___
/\/\ /\ | |
modified on Friday, February 01, 2008 9:04:54 PM
|
|
|
|
|
hi
I am working on my final Msc dissertation project, and in this project I have to impliment Disscussion Board ,
but I don't know what techniques normaly used to store "Dissussion Messages" at backend. whether database is used to store these or any other techniques?
If database is used to store these messages then what techniques is used for database to reduce memory storage.
If anyone have answer about this question please let me know by email at professional_awais@yahoo.com
Thanks
Awais
hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
|
|
|
|
|
Hi,
I made a little code, similar to original framework code: it can put attributes from XML "layout config files" into controls, created by LoadControl(type, object[]). This works fine with my Custom Controls.
(Is this a hack? What's the correct method to create "theme blocks" based on user editable XML file configuration?)
Problem:
When I load User Control based controls, using LoadControl(string+".ascx"), trying to reflect properties of this Control - the same way which works for Custom Controls - I cannot see any properties. Why?
foreach(string configName in configData.GetPropertyKeys())
{
PropertyInfo classProperty = control.GetType().GetProperty(configName);
if(classProperty != null)
{
if(classProperty.PropertyType == typeof(System.Int32))
....
classProperty is always null, when "control" is user control, based on UserControl and is loaded with LoadControl(string).
Works fine if control is custom control, based on Control, and is loaded with LoadControl(type, object[]).
Please help,
Ferenc
|
|
|
|
|
I have a word file in which some photos resides iam uploading this file.I want to list that file exactly in a dynamic page.
pls give me an idea about this, If the client machine doesn't have word what will be the outcome.
|
|
|
|
|
Hi,
I'm creating a Cahce in Web Service. When the Web Service or Web Server is down, whether the cache will be cleared or it ll be available.
If its available in the server, how can i remove when the service is down.
Kindly help me out to solve this issue.
Thanks in advance.
|
|
|
|
|
|
Hi,
I am using Microsoft AJAX autocomplete to lookup some product from database. I am wondering if it's possible to access onSelected event of the dropdownlist. Actually, what I want to do is only display product name in dropdownlist, and keep product ID in value field of the dropdownlist. When a user select an item from the dropdownlist, I will retrieve the product ID from the dropdown control for futher action. But since the webservice only return one string and that string is populated into dropdownlist automatically. I couldn't find how to set the text and value for dropdownlist using diffrerent values....
Did anyone have idea how to achieve it?
Any help would be really appreciated!
Thanks!
|
|
|
|
|
Hi,
The AutoCompleteExtender control was not really designed to be used with a DropDownList, as it can only return a string array to the client. If using a TextBox, as oppossed to a DropDownList, is not a viable option for you then you may need to look at writing a custom control that extends the functionality of the AutoCompleteExtender to return name/value pairs.
Clean code is the key to happiness.
|
|
|
|
|
We have a web application that is required to use HTTP post and get to pass data back and forth. Under IIS 6 everything works fine. The client receives the response (usually two packets) and everything runs as expected.
We moved the application to Visual Studio 2008, IIS 7, and converted our handlers to be properly recognized (not compatibility mode).
We still have all of our longer running transactions function normally. However our logoff transaction failed. I ran netstat and saw that with the login transaction that there was a port opened in a CLOSE_WAIT state. The GetResponse method works as expected. The logoff however shows no such port state and when the client goes to read the response it crashes because there is a stream object that goes nowhere. (no port in CLOSE_WAIT state or any other state)
I then went to the server side and stepped through our logic to issue the response to the client. In each case I get the status after the respond and it shows 200 OK as the response. Meaning the the transaction was a success and the response was a success. The last thing I do is flush the buffer. The only difference with the logout is that it is probably only 1 packet while even login is at least 2. If I pause the server right after the flush, the client takes off and successfully get the response object. If I do not pause it, the client crashes and no port is sitting in the CLOSE_WAIT state. We really need to get this fixed ASAP. Do I put a thread wait after the flush???? Will that stop the entire web server???? What do I do to get this working?
Thanks -- code for the WriteResponse is listed below.
Visual Studio 2008 -- IIS 7.0 -- Vista Ultimate with all updates applied
private void WriteResponse(HttpContext context, string response, ReplyCodeEnum reply, string replyText)
{
StringTemplate template = GetResponseTemplate(context, reply);
template.SetAttribute("code", ReplyCodes.GetCode(reply));
template.SetAttribute("text", replyText);
template.SetAttribute("response", response);
response = template.ToString();
context.Response.ContentType = "text/xml";
context.Response.Write(response);
context.Items.Add("Content", response);
string s = context.Response.Status;
context.Response.Buffer = true;
context.Response.Flush();
}
|
|
|
|
|
|
Thanks Mike.
Microsoft suggested first that we try context.Response.Close(); and see if that works.
I think it does the same thing but derived from the context object.
Michael
|
|
|
|
|
how can chak the input field is not empty when click on submit button
sanjeev
|
|
|
|
|
Hi,
If you are using ASP.Net then the RequiredFieldValidator control will provide you with a means to validate the input field on postback, and this will handle both client and server-side validation.
If you are not using .Net then I suggest you perform validation on the client-side using JavaScript, by attaching a validation function to the submit button's onclick event e.g.:
<input type='button' value='Submit' onclick='return checkEntry();'><br />
<br />
function checkEntry()<br />
{<br />
if (document.getElementById('textBox').value.length == 0) return false;<br />
return true;<br />
}<br />
And also server-side by validationg the contents of the textbox.
Clean code is the key to happiness.
|
|
|
|
|
Hi
its work but after getting value also it return false
sanjeev
modified on Thursday, January 31, 2008 4:29:38 AM
|
|
|
|
|
Hi,
If you took my code as was then you would need to change the type of the input control to submit, rather than button, as that will then cause a postback e.g.
<input type='submit' value='Submit' onclick='return checkEntry();' />
Clean code is the key to happiness.
|
|
|
|
|
thanks
it work fine but one thing i wants to add in it if length is 0 then alert massage also
thanks again
sanjeev
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
