|
SreejithAchutan wrote: sqlstatement &= "AND ((UserDtl.FName LIKE '%" & membername & "%')OR(UserDtl.FName " & "'" & Replace(Trim(membername), "'", "''") & "'" & ") OR (UserDtl.LName LIKE '%" & membername & "%') OR (UserDtl.MName LIKE '%" & membername & "%'))
You need to replace ' with '' (double "'").
For example.
<br />
membername = Replace(membername, "'", "''")<br />
<br />
sqlstatement &= "AND ((UserDtl.FName LIKE '%" & membername & "%')OR(UserDtl.FName " & "'" & Replace(Trim(membername), "'", "''") & "'" & ") OR (UserDtl.LName LIKE '%" & membername & "%') OR (UserDtl.MName LIKE '%" & membername & "%'))"
Hope it helps.
|
|
|
|
|
I want to include like statement also in search condietion.Please change the code i had given and send to me.
|
|
|
|
|
SreejithAchutan wrote: I want to include like statement also in search condietion.Please change the code i had given and send to me.
I already gave you the code.. Just the line that I make it bold before your statement..
|
|
|
|
|
Along with the like statement we can include the replace statement or use it as in the code .
|
|
|
|
|
Just copy this code. Okay?
sqlstatement &= "AND ((UserDtl.FName LIKE '%" & Replace(Trim(membername), "'", "''")& "%')OR(UserDtl.FName " & "'" & Replace(Trim(membername), "'", "''") & "'" & ") OR (UserDtl.LName LIKE '%" & Replace(Trim(membername), "'", "''") & "%') OR (UserDtl.MName LIKE '%" & Replace(Trim(membername), "'", "''") & "%'))"
|
|
|
|
|
I given like that but again an error occurs that Incorrect synatx near souza.
The code will be attached below plz check it and help me...
sqlstatement &= "AND ((UserDtl.FName ='" & Replace(Trim(membername), "'", "''") & "') OR (UserDtl.LName LIKE '%" & membername & "%') OR (UserDtl.MName LIKE '%" & membername & "%'))"
|
|
|
|
|
|
SELECT *
FROM dbo.a
WHERE (a LIKE '%d''%')
this will match
sfvvsf d'souza
svd'a
d'e
d'r
etc
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Thanks For your kind reply i Got it what i need.
|
|
|
|
|
I am having a grid view with check boxes assigned to each row.when i check them and click a button print i should dynamically take the grid views assigned to them and print pages accordingly.
|
|
|
|
|
use GridViewRow class from selected index for gridview and print it in predefine format !!!
|
|
|
|
|
how to add the wc report grid view contol in asp.net which was given in the article http://www.codeproject.com/KB/custom-controls/GridViewPrinting.aspx
|
|
|
|
|
Have you asked the author? Have you done even a cursorary search of how to use web controls?
only two letters away from being an asset
|
|
|
|
|
I am working on a ASP.net 2.0 website. I've set up a virtual directory thru iis on my machine and the site is functioning properly. Now, I copied all the aspx pages with the access database using my ftp login. I am recieving the following error:
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: The format of the file 'Microsoft.VisualStudio.DebuggerVisualizers' is invalid.
Also, at end of the error message it says this:
Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407
I believe it should say 2.0. What am I doing wrong? How to correct this?
|
|
|
|
|
Civic06 wrote: I copied all the aspx pages with the access database using my ftp login. I am recieving the following error:
From where are you copying the file ?
|
|
|
|
|
The database is placed in the App_Data folder. The entire folder which contains all the .aspx, .cs, .mdb files are moved using the FTP login onto appsitehosting.com.
|
|
|
|
|
I think there may be some problem with Framework on Hosting Sites. please Check This !!!
|
|
|
|
|
Civic06 wrote: I believe it should say 2.0. What am I doing wrong? How to correct this?
Does your hosting support ASP.NET 2.0? If they does then there should be option that you can switch from ASP.NET 1.1 to 2.0 in your hosting account. If you are not sure about option, you should contact with your hosting company..
|
|
|
|
|
Hi, im getting this problem
plz help me out....!!!!!!!!!!!!!
its urgent.
An error occurred loading a configuration file:
Failed to start monitoring changes to '\\stage\final\MyImagine\dv\inc'
because the network BIOS command limit has been reached.
For more information on this error, please refer to Microsoft knowledge base article 810886.
Hosting on a UNC share is not supported for the Windows XP Platform.
\\stage\final\MyImagine\dv\inc\web.config
Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...
|
|
|
|
|
ViReNdrA KuMaR KoHli wrote: For more information on this error, please refer to Microsoft knowledge base article 810886.
Have you checked the link? http://support.microsoft.com/kb/810886
ViReNdrA KuMaR KoHli wrote: \\stage\final\MyImagine\dv\inc\web.config
Why are you trying to load web.config from Shared Folder?
|
|
|
|
|
ViReNdrA KuMaR KoHli wrote: plz help me out....!!!!!!!!!!!!!
its urgent.
Nuclear war urgent, or "Im a paid empolyee and im incapable of searching the web for common error messages" urgent?
|
|
|
|
|
Maybe in between like Global Warming urgent. That way we can decide if we care or not.
|
|
|
|
|
Can I call a method in the parent page codebehind file from a user control?
In VFP I would do a This.Parent.MethodName([parameter List])
My user control gets a value, and I now with to pass this back to a method
that will update the parent form.
<br />
protected void SelectedIndexChanged(object sender, EventArgs e)<br />
{<br />
<br />
int tpiPk = int.Parse(GridView1.SelectedValue.ToString());<br />
RemoveGrid();<br />
Panel1.Visible = false;<br />
Session["AddressReturn"] = "hidden";<br />
iPk = tpiPk;<br />
RefreshPage(iPk);
<br />
<br />
}<br />
|
|
|
|
|
yes, if the method is public.
myPage obj = (myPage)this.parent;
obj.CallMethod();
You can also reference a control in the parent page.
Textbox txt = (Textbox)this.parent.findcontrl("txtId");
I didn't get any requirements for the signature
|
|
|
|
|
Could you point me to any examples where this methodology is used,
I'm a newbie at this so kind of picking it up as I go along.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
