Web Forms :: Like Statement Doesn't Work Properly
Sep 17, 2010
I wrote a statement such that
cmd ="select [title] from products where sku='% "3.5 caddy" %'"
this statement wont return anyfin where there is products with titles startin with 3.5 or ending with caddy or containing 3.5 caddy but just not together for example there is this title "3.5" IDE to USB 2.0 Aluminum External Silver HDD Enclosure Caddy" and that search of 3.5 caddy wont pick this item up as 3.5 is at the start and caddy is at the end.
View 1 Replies
Similar Messages:
May 8, 2010
I have written a bunch of T-sql code to my accessdatasource selectcommand. But I am having problem with where statement ! here is my code;
SELECT OWGBP, RTGBP, OWEUR, RTEUR, OWYTL, RTYTL, (SELECT Resort FROM Resort RF WHERE (View = True) AND (RF.ResID = TypePrices.ResID)) As ResortÄ°smi, (SELECT Destination + ' - ' + CodeOfDest FROM Destination TD WHERE (View = True) AND (TD.DestID = @DestID))
As DestIsmi, (SELECT TypeOFTrf FROM TRFTypes WHERE (TRFTypes.TRFTypeID = TypePrices.TypeOfTRF)) As TrasferTürü, @QADT As ADTSayi, @QCHD As CHDSayi, ([CHDPerCent]/100) As PerCHDCent, (ADTSayi ++ CHDSayi) As Deger, ResID FROM TypePrices WHERE ([View] = True)
And (ResID = @QRes) AND (Deger >= [MinReq]) AND (Deger <= [MaxCap])
And here is my select parameters;
[Code]....
It is a bit long ! I am having problem on last two where declaration. here ;
(Deger >= [MinReq]) AND (Deger <= [MaxCap])
those MinReq and MaxCap columns are int32 columns. But when I run the page it doesnt work properly ! It display the valuse it shouldn't be ! weird thing is, when I display this 'deger', I get the value properly. with this;
DeÄŸer : <b><asp:Label ID="Label10" runat="server" Text='<%# Eval("Deger")%>'/></b>
for example I get 8 with this but it dosnt work on where statement.
View 13 Replies
Jan 7, 2011
I thought that the "PageIndexChanged" is fired after the index has changed?
In other words when I'm at page 1 with a labelnumber 11 and I click on page 2, where the labelnumber =
22 and I do
the event "PageIndexChanged" I got the number "22" if I do the following code:
[Code]....
But that is not what happens I still got the labelnumber from page 1.
Did I understand the "PageIndexChanged" event wrong or is this a bug?
Because this is not working does somebody know how to solve this problem?
View 20 Replies
Jun 11, 2010
I'm new here and I need some help to use the AutoComplete Extender. I just have a default.aspx with a textbox extended with an AutoComplete. My Web Service calls a SQL Data Base thru Linq and return some account names.When I execute the WEB SERVICE and manually insert the parameters, it works! But when I execute the default.aspx, nothing happens. I really apreciate your help! See the CODES listed below:
See the Web Service code below:
[Code]....
Now, the code on DEFAULT.ASPX
[Code]....
I tried put the files in a remote SERVER, and I got the following error (in LOCALHOST I don't see that error):
Configuration Error
Server Error in '/PC' Application.
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: Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.
Source Error:
[Code]....
Line 8: <configuration>
Line 9: <system.web>
Line 10: <compilation debug="false" strict="false" explicit="true" targetFramework="4.0" />
Line 11: </system.web>
Line 12:
Source File: e:homeuysoftWebweb.config Line: 10
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.4028
View 7 Replies
Mar 24, 2011
I'm having a problem with this code:
[code]....
The thing is that, the first if statement works fine and the 'javascript' shows an alert and close the window, but in the second if statement the javascript shows the message but doesn't close the window.
View 2 Replies
Feb 28, 2011
I am drawing a grid using HTML and each tr element has it's own id. I want to be able to remove a tr on a button click, but not have to redraw the whole grid to show that the row has been deleted. I can do this using .hide(), but the problem is that I need to call a function to stripe my rows after, and since the row is still considered there, the striping doesn't work properly.
View 3 Replies
Sep 27, 2010
I want to use Ajax.BeginForm instead of Html.BeginForm.
I can use it with out OnSuccess option. When I include it, i doesn't save and give validaiton messages.
View 2 Replies
Feb 8, 2010
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
View 4 Replies
Mar 15, 2010
now i use the dataview to sort the seq of datatable and bind to repeater, it can only display the seq correctly.but i found that it is not the actual database seq, when i remove the row from the datatable, it is not remove the record that i see from the UI.do i need to sort the seq to the actual datatable not the dataview.now i use the seq (int) in datatable to sort the datatable as belows:
DataView view = dt.DefaultView;
view.Sort = "SEQ";
repeater.datasource=view;
repeater.databind();
View 4 Replies
Mar 2, 2010
why my upload control will not work properly when placed inside an ajax tab control? If I place it outside the tab control everything works great.Here is what I'm trying.
[Code]....
[Code]....
View 1 Replies
Mar 11, 2011
I am trying to save HTML content in a database. I have it stored properly but when I try to call it and display it on a page using a literal or label control, it does not show the content properly. It will show the text but not any HTML content (i.e. checkboxes, images, hyperlinks, etc)
View 9 Replies
Mar 13, 2010
I have a ListBox1 on the Form that I read in the same Directories: "GetS" as in the code below.
Now I select the first index wich is 0 in the listBox with the mouse and press Button1.
What the code below does is to find that specific folder that also contains a .BMP file and a file: File1.txt
So I will first delete the .bmp file and the File1.txt and at last the directory.
My problem is as follows. When I press Button1 the First time, nothing at all was deleted but the second time I press the Button1, the .BMP file and the File1.txt were delete fine.
But the code breaks at this line and says that the directory isn´t empty. But the directory is empty as I can see when open it manually.
So initially my problem is why the .BMP, File1.txt and the directory aren´t deleted at the first press of Button1 ? (ListBox1 has AutoPostBack set to TRUE and everything is put inside an updatepanel)
[Code]....
View 7 Replies
Mar 9, 2011
I have a Datagrid one of the colums is a checkbox and when it is selected I' m supposed to update that row. I have a button to update this outside the Datagrid. It seems to work well for the first two rows but after that meaning starting 3 to any it just doesnt update no errors but doesnt update. When I look into the id it seems to be empty.
Private Sub btnInactivateAllSelected_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnInactivateAllSelected.Click
'
'Function declarations
Dim currentMethod As String = MethodBase.GetCurrentMethod.Name
'Object declarations
'Variable declarations
Dim ruleID As Guid = Nothing
Dim oRule As PSXSTL.Digecenter.Rule = Nothing
Dim changetext As String = Nothing
'Start Try...Catch statement
_moduleName = "btnInactivateAllSelected_Click"
Try
For Each item As DataGridItem In GroupDataGrid.Items
If CType(item.FindControl("chkApprovalCheck"), CheckBox).Checked = True Then
ruleID = GroupDataGrid.DataKeys(CInt(item.ItemIndex))
oRule = New PSXSTL.Digecenter.Rule(DirectCast(Session("CustomerID"), Guid), ruleID)
If oRule.Complete Then
oRule.RuleStatus = False
oRule.ActiveDate = Now.ToString
changetext = "On " + Now + " " + Session("FirstName") + " " + Session("LastName") + " deactivated the Rule."
If Not oRule.ProofReviewed Then
changetext = changetext & " PDF not viewed"
End If
LogEditHistoryItem(changetext, ruleID)
' Call
' added 10/19/2004 by Rob MacMorran
LogBulkOrderHistory(oRule)
oRule.Update()
End If
oRule.Dispose()
End If
Next
' Server.Transfer("customer_clientrules_results.aspx")
Catch ExceptionObject As Exception
'Write the exception out to the event log.
EventLogHelper.LogException(ExceptionObject, _moduleName, "Error occurred in " & _moduleName & "/" & currentMethod & ControlChars.CrLf & ExceptionObject.StackTrace, EventLogEntryType.Error, 55555)
Finally
'Cleanup
'Object disposal
If Not oRule Is Nothing Then
oRule.Dispose()
oRule = Nothing
End If
'Variable disposal
ruleID = Nothing
changetext = Nothing
'Function variable disposal
currentMethod = Nothing
End Try
Server.Transfer("customer_clientrules_results.aspx")
End Sub
View 5 Replies
Mar 23, 2010
I have a website that I am trying to publish and it doesn't seem to be working properly. I get an error saying that a master page does not exist. However, the master page is there, but when I publish the code, it does not get published. Is there some sort of cache or something I am missing here?
View 7 Replies
Feb 27, 2011
I am using 2 jquery plugins
1. to display one line of breaking news
2. to display a news ticker
each one uses an unordered list to display in the begining of the page loading the list is displayed with all its items under each other in an ugly way then it returns to the normal one line style.
I wish a way to display these lists properly from the begining of the page loading
[URL]
here is the jquery call to them
1. the breaking news list
<script type="text/javascript">
$(document).ready(function ()
{
//jQuery Cycle Fade option
$('ul#newsfade').cycle({
fx: 'fade',
[Code]....
View 6 Replies
Oct 7, 2010
i'm trying to make this work for several days but it just doesn't work.
this is my code:
aspx page:
[Code]....
webservice:
[Code]....
this was downloaded from this website.
the problem is that the page loads fine but no autocomplete occurs.
View 5 Replies
Apr 15, 2010
I have both the wcf and asp.net project together in the same project. (I'm running on Azure, so this is more convenient).I have this set in the web.config:
<system.serviceModel>
<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
</system.serviceModel>
y wcf service is decorated with:
[code]...
View 1 Replies
Aug 12, 2010
I have one loginView Control . initially when the login screen loads it will show user name and text box controls and user will be able to enter text into it ,when user tries for the second time to login, the login control doesn't load or display the user name and text box controls(the username text box and password text box controls disappears). the following is the code that i have written.
[Code]....
View 4 Replies
Jan 14, 2010
I'm using ASP.net 2.0. I want to set a calendar control's selected date to 30 day before today. My code is like this:
theCalendar.SelectedDate = DateTime.Now.Today.AddDays(-30);
but It does not work.
View 1 Replies
Feb 14, 2011
I have such markup:
div id="wrapper"
nested table
text here
here
and here
the same thing here
here
and here
View 2 Replies
Feb 11, 2011
I'm managing a rather large project, written in asp.net webforms + mvc3, with a large user base, and a pretty high daily visitor count. Basically, there are a lot of requests at any given moment.
One of my controllers in MVC that handles / resizes images on the fly has the following attribute applied to it:
[SessionState(SessionStateBehavior.Disabled)]
Now, if an action in the controller tries to access the session - it obviously throws an exception - so we're good so far. The problem is: if I go to the IIS Worker Processes window (Win Server 2008 R2, IIS 7.5), and check the current requests for this site, I can sometimes see the requests to an action in this controller. Their current state is locked in State: RequestAcquireState, Module Name: Session. Sometimes these locks go over a second or two in this state.
Wasn't the whole point of the attribute in the first place to make the requests to the controller ignore the state, and not waste time (and possibly being locked) trying to acquire the state? If this is so - am I doing something wrong here, or does the problem lie elsewhere?
View 1 Replies
Nov 3, 2010
In my website I wrote that code:
protected void Page_Load(object sender, EventArgs e){ LinkButton lbtnTopicAddress = new LinkButton(); lbtnTopicAddress.Click += lbtnSpecificTopic1_Click;}
protected void lbtnSpecificTopic1_Click(object sender, EventArgs e){ Server.Transfer("~/SpecificTopic.aspx)"
}
But when I press on the link in run time, the caller doesn't go to the EventHandler method.Why?
Note,
I wrote code like that in many pages in the same website but it work only in one page.
View 2 Replies
Dec 8, 2010
i am still new to using session state, i want to convert page name into and integer according to a database table a function then compares "X" and "Y" to check if a user have the right to view this page i know this is not the best way of managing website security, but it is like "training on how to use the session" what have i done wrong
Partial Class advancedsearch
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
Label1.Text = Session("username").ToString
Label3.Text = Session("role").ToString
Label4.Text = System.IO.Path.GetFileName(Request.Url.ToString())
Catch ex As Exception
Response.Redirect("login.aspx")
End Try
If Label1.Text = "" Then
Response.Redirect("login.aspx")
End If
Dim x As Integer = Int32.Parse(Label3.Text)
Dim y As Integer = Int32.Parse(DropDownList1.SelectedItem.ToString)
If x < y Then Response.Redirect("login.aspx")
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Response.Redirect("default.aspx")
End Sub
End Class
View 1 Replies
May 11, 2010
I am a new to WCF. I have written ajax to use a web service before, but on this project I am trying to use ajax to WCF.After I build the project and wcf using ajax, I receive the return successfully. But, 10 or more minutes later I don't get a return, the ajax calls the error function, and the fiddler returns nothing.
If I rebuild the project without any source modifying, I receive the return successfully again.
View 2 Replies
Aug 27, 2010
I designed a simple site with some css and jquery. All the css is in the header using and the javascript files are in a folder called Scripts and referenced in my site like below. Everything is beautiful locally, but on the server some objects such as a couple of my divs are out of their original positions, and my dropdown menus that use jquery don't work properly but they do work somewhat (like they slide down or fade). I have made identical folder structure in root on the web server. I am using .NET 3.5 and the server does support it.
Do you guys think it can be a path issue for my scripts? What could cause the css to move divs out of position? Does css or jquery behave differently on different servers?
<script src="Scripts/jquery.validate.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.validate.min-vsdoc.js" type="text/javascript"></script>
<script src="Scripts/jquery.validate.js" type="text/javascript"></script>
<script src="Scripts/jquery.validate-vsdoc.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.4.1.min-vsdoc.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<script src="Scripts/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.easing.1.2.js" type="text/javascript"></script>
<script src="Scripts/jquery.color.js" type="text/javascript"></script>
<script src="Scripts/jquery-ui-1.8.4.custom.min.js" type="text/javascript"></script>
View 5 Replies
