|
Member 1021252 wrote: and you need tocuh screen moniters to run that.
Really? That's the definition of a Kiosk?
|
|
|
|
|
Hi,
I need to insert a string variable with '(single quotations)into the sql server 2005 database. I tried to insert it in the normal method. But I am getting an error while inserting it. For example
string str="Hi 'Please help me' programers";
SqlCommand cmd1 = new SqlCommand("INSERT into Table1(Message) values('"+str+"')",con);
I have to insert the exact string without any modifications into the database. Please if anyone know solution please help me.
Thank you.
|
|
|
|
|
Use double single quote in place of one single quote
The miracle is this--the more we share, the more we have.
|
|
|
|
|
Try this
SqlCommand sqlCmd = new SqlCommand("INSERT into Table1(Message) values @str ", dbConn);
sqlCmd.Parameters.AddWithValue("@str", str);
|
|
|
|
|
I think sumit's answer is the best one...
using SqlParameters will remove the possibility of sql injection as well.![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
you can use some other symbol and replace it at time of rendering the value for that.
For example before inserting replace with say # and while rendering change it back to '
Hope this helps
Puneet
|
|
|
|
|
string _scriptCloseDialog = "<script>alert('Lead ID should be 9 digit long');</script>";
ClientScript.RegisterStartupScript(GetType(), "_load", _scriptCloseDialog);
I want to add Yes No Buttons in this MessageBox...Please help....
Thanks...
|
|
|
|
|
use confirm dialog in place of alert...
The miracle is this--the more we share, the more we have.
|
|
|
|
|
string _scriptCloseDialog = "<script>confirm('Are you sure');</script>";
ClientScript.RegisterStartupScript(GetType(), "_load", _scriptCloseDialog);
I want to compare this messagebox value...how to campare?
|
|
|
|
|
if (confirm("Are you sure you want to delete the custom search?")==true)
return true;
else
return false;
The miracle is this--the more we share, the more we have.
|
|
|
|
|
I am new for this JavaScript code...
I am writing code in .CS file...
There I want to compare MessageBox Value...
string _scriptCloseDialog = "<script>confirm('Are you sure you want to delete?');</script>";
ClientScript.RegisterStartupScript(GetType(), "_load", _scriptCloseDialog);
can i compare this line of code?
ClientScript.RegisterStartupScript(GetType(), "_load", _scriptCloseDialog);
Please advise.. 
|
|
|
|
|
Hai,
i used an file upload and image button in my aspx page, i give two image paths for save and update(\images\save.gif and \images\update.gif) , i want the checkin in javascript path of image button is \images\save.gif then one alert otherwise another? how please help me?(asp.net,c#),first i used the button for save and update,at that time in javasript i used the code is
if(document.getelementbyid("ct100..._btnave").value=0)
{
if(document.getelementbyid("ct100..._fileimage").value.length==0)
{
alert("icon field cant be empty")
}
}
at that time,working is correct after that i changed button to image button? text property is not in image button,but i ysed two image url for save and update?how to writ this code image button instead of button?
modified on Thursday, March 5, 2009 10:50 PM
|
|
|
|
|
Please post your Question very clearly.
R.Palanivel 10:01 4 Jan '06
|
|
|
|
|
file upload control show no file when using in update panal otherwise it working fine.
|
|
|
|
|
|
i got yhe solution . we jusr have to add trrigers on button on which we r saving the data of file upload control.this will also help.
http://geekswithblogs.net/ranganh/archive/2008/04/01/file-upload-in-updatepanel-asp.net-ajax.aspx
|
|
|
|
|
I have a problem like this I make HtmlInputButtons in function and I add there EventHandlers for them. However when I do serverclick function does't work. I know that handlers should be in Page_Load but these buttons must be added in function.
example code:
Page_Load()
{
bt+=EvantHandler(bt_Click);
}
public void bt_Click(object sender,EventArgs e)
{
for(int i=0;i<5;i++)
{
HtmlInputButton ib=new HtmlInputButton();
ib.ID="bt"+i;
it.serverClick+=EventHandler(it_Click);
}
}
public void ib_Click(object sender,EventArgs e)
{
}
If anybody know how do it??
|
|
|
|
|
use button class instead of HtmlInputButton(). It is always good use Asp button when you use server side codes.
The miracle is this--the more we share, the more we have.
|
|
|
|
|
I would like to know the use of the repeater? and where it should be used.
|
|
|
|
|
MSDN[^] says,
Repeater is a data-bound list control that allows custom layout by repeating a specified template for each item displayed in the list.
It is clear, isn't it? 
|
|
|
|
|
repeater repeats the html that you provide inside it. You can evaluate the data from inside the repeater to get the current data objects.
For further enquery read:
Use of Repeater[^]
|
|
|
|
|
I have two dropdown in my form called Project and Company. First dropdown will list the projects and on the basis of projectid, company dropdown is filled.
Inorder to avoid going back to database again, I have framed an sql query in such a way that it will give the projectid, projectname, companyid and company name in one shot. By default, the first projectid will get selected. Now how will I populate the company dropdown with this projectid without using another query? The data is already fetched. How should I store and retrieve the data so that I can use it again?
Any idea of this? Hope you have cleared my question. Please help.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
What is the use of Auto post back? Can anyone explain?
|
|
|
|
|
Karthick_gc wrote: What is the use of Auto post back? Can anyone explain?
Yes. Check Here[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Well! auto post back causes the page to be posted back to the server after an event has occurred. For E.g For a drop down if the page has to be posted back if an option has been selected then we can use AutoPostBack = true for that control. Using this property we need not write the _doPostBack() method in Javascript.( actually .NET inserts this method when we use AutoPostBack = true.)
"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
