|
hi all
i am submitting a query like
insert into test(PID,Details)values(2,'"+txtdetails.Text+"')
problem with me if the txtdetails contain the string like
"amit's bother resides in delhi"
the character(') create a problem. i don't want any loop to check the index of the character(') because the string is too large having number of character like(').
please just i want a simple query to insert the string.
thanks in advance,
srinandan
|
|
|
|
|
insert into test(PID,Details)values(2,'"+txtdetails.Text+"')
used command parameters
int ptd1=2;
cmd = new SqlCommand("Insert into test(PTD,Details) values (@ptd,@details1)",connection name)
cmd.Parameters.Add("@ptd",ptd)
cmd.Parameters.Add("@details1",txtdetails.text.trim());
myconn.Open();
cmd.ExecuteNonQuery();
myconn.Close();
or simple insert 2 and use parameter for second one.
anuj
dcjoshi2
|
|
|
|
|
I don't know a simple way.
You should do:
string str = "this is a 'sample string'";
str = str.Replace("'", "''");
thats all.
Try it!
elaj
|
|
|
|
|
|
I have two button on each row of a dtatgrid, I want to capture the onclick event of each button and call a function, the onclick event i want to capture is the server side event as i want to update the database
<asp:buttoncolumn text="Down" buttontype="PushButton" headertext="Down">
<asp:buttoncolumn text="Up" buttontype="PushButton" headertext="Up">
|
|
|
|
|
use itemCommand event of the datagrid
Thomas
|
|
|
|
|
ok so i have, please see the comment within function, thanks in advance
Private Sub dgHeaders_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dgHeaders.ItemCommand
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
'in here how do i know which button was clicked
End If
End Sub
|
|
|
|
|
Set the CommandName property of each button in html and you can check that name using e.CommandName
Thomas
|
|
|
|
|
thats working perfectly,
Thank you very much thomas
|
|
|
|
|
Hi,
I was trying to send a number from a HTML textbox to add a value to it at the Server, then return it to an ASP textbox.
But I don't know to to pass the value of the HTML textbox to the server.
The 2 Javascript functions are:
<script type="text/javascript">
//the first function to call the server
function GetNumber() {
UseCallBack();
}
// The function receive the adjusted value from the server and display it into the textbox1
function GetRandomNumberFromServer(arg, context) {
document.forms[0].TextBox1.value = arg;
}
</script>
Here are the server side code, written in the .vb file:
Dim _callbackResult As String = Nothing
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim cbReference As String = Page.ClientScript.GetCallbackEventReference(Me, _
"arg", "GetRandomNumberFromServer", "context")
Dim cbScript As String = "function UseCallBack(arg, context) {" & cbReference & "}"
Page.ClientScript.RegisterClientScriptBlock(Me.GetType(), "UseCallBack", cbScript, True)
End Sub
Public Function GetCallbackResult() As String Implements System.Web.UI.ICallbackEventHandler.GetCallbackResult
Return _callbackResult
End Function
Public Sub RaiseCallbackEvent(ByVal eventArgument As String) Implements System.Web.UI.ICallbackEventHandler.RaiseCallbackEvent
_callbackResult =
'equal the value from the HTML textbox + 5
End Sub
Does anyone know where I can add some code to ask to pass the value to the Server?
Thanks,
-- modified at 4:30 Tuesday 3rd October, 2006
|
|
|
|
|
Hi,
I get this error randomly, please explain possible reasons..
Owner: ASP.Default_aspx
Type: IBM.WMQ.MQException
Source: amqmdnet
Description: CompCode: 2, Reason: 2018
Exception: CompCode: 2, Reason: 2018
Thanks
Mohan
|
|
|
|
|
Hi Mohan,
Did you integrate .Net application/Servers with IBM websphere MQ (IBM MQSeries).
With Regards
Satips
|
|
|
|
|
Yep, that is done & the website runs fine except this error occasionally & this error occurs when the page is not accessed for a while. But it doesn't sound to be a timeout issue, I’ve checked this.
|
|
|
|
|
|
i need to make web parts for which i need codes,please suggest me a web site from where i can get the required codes . mine is an asp.net application with c# as codebehind developed in .NET 2003 (i.e .NET 1.1)
|
|
|
|
|
Don't repost the same question.
With Regards
Satips
|
|
|
|
|
i have visited the site which you have given against my previous question but that site is for .NET 2.0 my application is in .NET 1.1,hence i mentioned that my application is in .NET 1.1 and reposted the question.
thanks
|
|
|
|
|
I have worked it in 2.0 only. Not in 1.1.
With Regards
Satips
|
|
|
|
|
Hi,
I want to read the XML values from an web page. For example i want to read the XML values from the below web page and i want to use or print it in my page.
http://www.flashasp.net/forum/Default.aspx?g=rsstopic&pg=forum[^]
How to do this?? Can any one suggest me how to read this or print this on my page???
Know is Drop, Unknown is Ocean
|
|
|
|
|
Hi,
With the help of Ajax you can read the xml values from an web page.
Happy coding,
With Regards
Satips
|
|
|
|
|
Hi,
Thanks for you help. Shall you explain it more with an example? Because i dnt have idea about Ajax.
Thank you very much
Know is Drop, Unknown is Ocean
|
|
|
|
|
|
how to -Develop a webpart which will display all the sites and sub sites.
For each site, it should display the name of all the web parts contained in that site.
This webpart when placed in any site should behave the same.
If any webpart in the site is hidden, specify accordingly.
using asp.net and c# .My application is in 2003 .NET (i.e .NET 1.1and not in .NET 2.0)
|
|
|
|
|
How can I schedule an ASP script to run at a certain time each day?
Thanks!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
