|
i am using ASP.net, C# anD SQL Server2005,in the following query:
string q = "SELECT collapsed_building.b_name,collapsed_building.b_desc FROM collapsed_building WHERE collapsed_building.b_name LIKE '" + crimewithdate.text2 + "' ";
I WANT TO USE % AFTER THE Khow to use the keyword LIKE in the SQL query in C# statementEYWORD like SO THAT ALL THE BUILDING NAMES WHICH MATCH THE VALUE ENTERED BY THE USER ARE DISPLAYED
WHEN I WRITE (LIKE '" + %crimewithdate.text2 %+ "'), IT GIVES ERROR, WHAT WILL BE THE CORRECT SENTAX
|
|
|
|
|
|
hello there, you should write it like this
string q = "SELECT collapsed_building.b_name,collapsed_building.b_desc FROM collapsed_building WHERE collapsed_building.b_name LIKE '%" + crimewithdate.text2 + "%'";
not like what you wrote...
Web Developer @ Silverkey Egypt
|
|
|
|
|
|
I have developed an application whose users are categorized into two levels(Guest,Administrator). For this I have changed my web config file and include following lines
<sitemap defaultprovider="MySiteMapProvider">
<providers>
<add name="AdminSiteMapProvider">
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="Sitemaps/admin.sitemap"
securityTrimmingEnabled="true">
<add name="GuestSiteMapProvider">
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="Sitemaps/guest.sitemap"
securityTrimmingEnabled="true">
and also
Set SiteMapProvider property of SiteMapDataSource. see following code:
SiteMapDataSource1.SiteMapProvider = "AdminSiteMapProvider"
Problem is that when i execute the application i gives me the following error:
Parser Error Message: The provider 'sqlSiteMapProvider' specified for the defaultProvider does not exist in the providers collection.
Please help me in this regard.
Thankyou
|
|
|
|
|
Zeeshan Memon wrote: Parser Error Message: The provider 'sqlSiteMapProvider' specified for the defaultProvider does not exist in the providers collection.
The correct spelling is SqlSiteMapProvider.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
When i click on print button of crystal report tool bar, it reloads the report and after click on OK button of Print dialog box it again take time as much as on report loading.
My main question is that, is there any another way to print report without reloading once it loaded.
The great pleasure in life is doing what people say you cannot do.
|
|
|
|
|
Hi, I have designed a site using vs2008 and .net framework 3.5. Everything works perfectly in our development environment.
However when we upload all files to Production Server, we recieve the following error when browsing to the website "asp.net client side framework failed to load".
We have also copied all the code across and receive the same error so it is not a deployment issue it has something to do with the box. Are there any special Security settings that we may have missed? The box still runs the 2.0 version of the site fine. We are using IIS6 and we have installed the 3.5 framework on this box.
Note: In Production server does not have vs2008 but have .net framework 2.5 & AJAX framework 3.5
Any suggestions would be appreciated
Thanks in Advance
Hemadri
MuniHemadriBabu.Jogi
|
|
|
|
|
|
I use a gridview to display a list of records. Each record has a "View" button attached to it, which you can click and view the details of
the particular record. In the "View" page there is a "back" button which you click to take you to the Gridview displaying the list.
The problem I have is when I go to say page 2 on the Gridview and then I click to "View" a record, when I click the back button it will always
return me to page 1 of the Gridview and never to the page I had just been on.
Here is the code in the back button:
Response.Redirect("DisplaySearch.aspx?Id=" & Request.QueryString.GetValues("Id")(0) & "&DateFrom=" & Request.QueryString.GetValues("DateFrom")(0) & "&DateTo=" & Request.QueryString.GetValues("DateTo")(0) & "&Name=" & Request.QueryString.GetValues("Name")(0) & "&BehalfOf=" & Request.QueryString.GetValues("BehalfOf")(0) & "&RefNo=" & Request.QueryString.GetValues("RefNo")(0) & "&Section=" & Request.QueryString.GetValues("Section")(0) & "")
Anyone any ideas on this?
macca
|
|
|
|
|
Send the PageIndex along with the View URL. Make use of it when you return back from the View page.
|
|
|
|
|
|
How are you navigating to the Detail page when the View button is clicked?
|
|
|
|
|
The following response.redirect :
Response.Redirect("DisplaySearch.aspx?Id=" & Request.QueryString.GetValues("Id")(0) & "&DateFrom=" & Request.QueryString.GetValues("DateFrom")(0) & "&DateTo=" & Request.QueryString.GetValues("DateTo")(0) & "&Name=" & Request.QueryString.GetValues("Name")(0) & "&BehalfOf=" & Request.QueryString.GetValues("BehalfOf")(0) & "&RefNo=" & Request.QueryString.GetValues("RefNo")(0) & "&Section=" & Request.QueryString.GetValues("Section")(0) & "")
|
|
|
|
|
macca24 wrote: Response.Redirect("DisplaySearch.aspx?Id=" & Request.QueryString.GetValues("Id")(0) & "&DateFrom=" & Request.QueryString.GetValues("DateFrom")(0) & "&DateTo=" & Request.QueryString.GetValues("DateTo")(0) & "&Name=" & Request.QueryString.GetValues("Name")(0) & "&BehalfOf=" & Request.QueryString.GetValues("BehalfOf")(0) & "&RefNo=" & Request.QueryString.GetValues("RefNo")(0) & "&Section=" & Request.QueryString.GetValues("Section")(0) & "")
Add the PageIndex of the GridView as a querystring along with this URL.
|
|
|
|
|
yes, but what I am asking is how do you do that?
|
|
|
|
|
I have a gridview which I have made changes to in the development environment, but when I copy across to the live production environment
the changes do not show up.
Anyone any idea why this is??
macca
|
|
|
|
|
macca24 wrote: I have a gridview which I have made changes to in the development environment
Is it a Custom Control Library? If so, have you updated the reference in the production environment?
If you have done the changes in the Page level itself, did you changed the codebehind? If so, have you published it and updated the binaries in the Bin directory of the production environment?
|
|
|
|
|
I have completely deleted the project from the Production Environment and re-copied the project from development and it is still not working. It is like it is caching the old version of the system and not reading the new version I have put in.
Any ideas?
macca
|
|
|
|
|
You haven't answer any of my questions. Sorry...
|
|
|
|
|
Excuse me, what does that mean ??
|
|
|
|
|
The GridView you are using is a custom control or the same GridView which comes with .NET Framework?
|
|
|
|
|
Yes, is gridview tht comes with .net 2.0.
|
|
|
|
|
clear the internet temprory fiels and cookies.
|
|
|
|
|
I have a dropdownList. I want to that insert the (i to NowRec) in dropdown list using by for loop eg. I wrote the below code. but this is wrong. Please write a right code.
for (Int32 i = 1; i <= Convert.ToInt32(NowRec); i++)
{
ddlequipmentno.Items.Insert(0, i.ToString());
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
