Check The Range And Number Of Records In That Range Without Using Cursor?
Jan 13, 2010
I have a table "RANGES" with the following columns
LowRange as int
HighRange as int
with the data similar to below
select * from Ranges
LowRange HighRange
1 100
101 200
201 300
.
.
.
901 1000
And another table "infoDetails" with the following columns
Range as INT
amount as money
with the data similar to below
select * from infoDetails
Range Amount
23 34.00
235 44.00
345 34.00
678 100.00
555 100.00
530 100.00
510 100.00
I need one report with the following format without cursor.
LowRange HighRange Count Amount
1 100 1 34.00
101 200 0 0.00
.
.
501 600 3 300.00
601 700 1 100.00
I have a Range Validator as follows. It is for restricting values between 1900 and 2070. However, it fires error when I enter a alphabet also. I want this to be fired only if the user enters integer values. How do I overcome it?
When using a range validator, if the user exceeds the defined range, How do you code it so it disables a button so the user can't continue. (without using JavaScript)
We are writing a feature that allows an administrator to block/allow ranges of ip addresses.
Is this easy enough to do with c#?
I was thinking of looking at each number [here].[here].[here].[here] and then mathing it with the ranges and just seeing if each number was between the two?
I'm trying to build up some regular expressions to validate some textbox controls. I have done some research and testing but cannot get this one working. Examples of what i am trying to create regular expressions for are as follows:
Range 0-45, 0 decimal places Range 0-20, 2 decimal places Range 16-65, 0 decimal places Range 0-99, 2 decimal places Range 0-1500000, 0 decimal places Range 0-200, 1 decimal place
For 1 and 5 respectively, I have used
([0-9]|[0-9]d|45)$ ([0-9]|[0-9]d|1500000)$
The first one I am having problems for is an age range of 16-65 (inclusive), where I want no decimal places. After a post on here (Regular expression to allow numbers between -90.0 and +90.0) I thought I could use the logic and get it sussed, but can't! The expression I got to was:
If we let users input a couple of ip ranges, e.g., 172.16.11.5 - 100, how could I write a fucntion to check if a IP (172.16.11.50) falls in the ranges?
Is there any existing library in .NET to leverage?
I am getting Range1 and Range2 from database. Dataset is like below.
Range1 Range2
AB100 XY200
AB300 XY400
AB500 XY600
I have to bind these ranges to a Drop Down List as list items includung range number in my application.So list item should be like ==> 1 AB100 XY200 . When user selects a range I have to pass Range1 and Range2 to database.How can I bind the two ranges with range number to Drop Down List.
I'm using the ASP Validation control a wanted to test that multiline textbox content was between 2 and 40 characters. Any character can be provided, including the new line character. What would be the expression? What I have below fails.
for some SQL queries I know the expected number of rows that must be affected by UPDATE, DELETE or INSERT statements. It could be a number such as 1 or a range such as 0-1 or 1-2 etc.
What is the best way to enforce that this is the number of affected rows and that otherwise an exception is thrown?
Also, can I limit the number of rows affected for UPDATE/DELETE/INSERT to say 1 row and otherwise get an exception?
I want to validate a number by regular expression. Here is the requirement.
1- It should be between 1 and 200 2- maximum 2 floating point (e.g. 24.54 accepted but not 24.546) 3- the radix point can be either Dot or Comma (e.g. 29.45 - 29,45 both accepted) 4- can be intiger in this range also (e.g. 24 or 24.00)
Can anyone post an efficient regular expression for this?
after running my application it executes fine with no exception but such error i am getting, A number range is required here. Error in File
C:DOCUME~1DelmonLOCALS~1TempPumpTestReport {14E557A7-51B3-4791-9C78-B6FBAFFBD87C}.rpt: Error in formula . '{View_EODPumpTest.ROId} IN ['15739410','13465410'] AND ({View_EODPumpTest.RecordCreatedDate}>=date(2010 , 12 , 1)AND{View_EODPumpTest.RecordCreatedDate}<=date(2010 , 12 ,25 ))' A number range is required here. error.
I need to filter data based on a date range. My table has a field Process date. I need to filter the records and display those in the range FromDate to ToDate.
and i am facing problem while inserting the record.
eg:
if the room is already booked from 1st march 2010 to 10th march 2010.and if anybody is booking the same room from 4th march to 9th march it should show error message stating that
this room is already booked from 1st march to 10th march.
I have the following code. What's happening is, on postback, the required attribute for sequence will fire. If it passed, the range check is skipped completely. If it fails, it never gets to the range check either. Have I coded something wrong?
using System.ComponentModel.DataAnnotations;namespace Venue.Models{ [MetadataType(typeof(CategoryMetadata))] public partial class Category { } public class CategoryMetadata { [Required(ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "sequence_required")] [Range(0, 9999, ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "sequence_invalid")] public int Sequence { get; set; } [Required(ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "title_required")] [StringLength(256, ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "title_invalid")] public string Title { get; set; } }}
I am getting Range1 and Range2 from database. Dataset is like below.
Range1 Range2
AB100 XY200
AB300 XY400
AB500 XY600
I have to bind these ranges to a Drop Down List as list items includung range number in my application.So list item should be like ==> 1 AB100 XY200 . When user selects a range I have to pass Range1 and Range2 to database.
How can I bind the two ranges with range number to Drop Down List.
I want to put validation in a Textbox, that the numbers entered inside textbox should be between 1 to -1 only i.e., (-1, -0.1, -0.2, -0.3, -0.4, -0.5, -0.6, -0.7 ....... 1 )I tried below code but "RangeValidator" is not working as per requirement:
HTML:
<asp:RangeValidator ID="RangeValidator1" runat="server" MaximumValue="1" MinimumValue="-1" Text="value between 1 to -1" ErrorMessage="value between 1 to -1" ControlToValidate="TxtY" ValidationGroup="usrvalid"></asp:RangeValidator> <asp:TextBox ID="TxtY" Text='<%#Eval("Y") %>' runat="server" Width="30%"></asp:TextBox> <cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender5" TargetControlID="TxtY" FilterType="Custom" ValidChars="-01234567890." runat="server"></cc1:FilteredTextBoxExtender>
i need to query a table which normally will return multiple records for the id and I need to loop through probably using a cursor and pull values out from each record to make a string.
what is the syntax for this? i've seen cursors using a set number (EX: loop through 5 times) but I need to create a query so that I can loop through once for each row returned from my query.
I has developed a crystal report, which display the records from a table and filters them based on a parameter( date range parameter). now I has integrated the report into a asp.net page using c#, but when I am running the asp page it is not promption for the date range values, it used to prompt for date range when I run the report in crystal report.