I have not been able to fiqure out how to take list intergers and find all the ranges in it. If I had a list with 0, 1,2,4,6,7 I like to create a string that show the ranges are 0 - 2 and 4-7 I'm having no problem creating the list and sorting it, just stuck on how to work after that point.
View 9 Replies
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 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 am learning jQuery. Here I have a requirement i.e I have to add Week number and Week ranges of a year to Drop-down List in ASP.NET3.5. And I have to pass selected week range to database. I am using c#.net. This should be done automatically for every year.
How can I do this using jQuery?
Perhaps someone has done something like this before. I am generating a quantity summary report. The quantities have to be summarized in two ways:A quantity for a specified date range, which can fall anywhere within the project duration defined by the user provided UserStartDate and UserEndDate A Quantity to date, defined by the ProjectStartDate till the user defined UserEndDate So if I put all these dates in sequence it would look something like this: ProjectStartDate, UserStartDate, UserEndDate, ProjectEndDate Right now in the code the User specified dates are vStartDate and vEndDate. The source data (list of bid items) is compiled in a UNION query (SqlServer View) and I am querying from this view using a stored procedure from which the data is captured using the code below.
Public Shared Function GETeFieldQuantityData( _
ByVal vProjectNo As String, _
ByVal vStartDate As DateTime, _
ByVal vEndDate As DateTime) _
As IEnumerable
' Dim SqlConnection, SqlCommand, and SqlDataReader
Dim vSqlConn As SqlConnection = New SqlConnection(GetConnString)
Dim vSqlCmd As SqlCommand = New SqlCommand("eFieldReturnQuantitySummary", vSqlConn)
'Dim vDataRdr As SqlDataReader
vSqlConn.Open()
'Construct parameters
vSqlCmd.Parameters.AddWithValue("@StartDate", vStartDate)
vSqlCmd.Parameters.AddWithValue("@EndDate", vEndDate)
vSqlCmd.Parameters.AddWithValue("@ProjectNum", vProjectNo)
vSqlCmd.CommandType = CommandType.StoredProcedure
'Return SqlDataReader Object
Return vSqlCmd.ExecuteReader(CommandBehavior.CloseConnection)
End Function
And the SELECT statement returning data to the form:
Code:
SELECT BidItemDesc As [Bid Item Description], Unit,
SUM(Qty) AS [Tot Qty], COUNT(*) AS Records
FROM dbo.qryQuantityWorkSheet
WHERE ((ProjectNum = @ProjectNum)
AND (ProjDate >= @StartDate)
AND (ProjDate <= @EndDate) )
GROUP BY ProjectNum, BidItemDesc, Unit
ORDER BY BidItemDesc
Would anyone have any ideas of how to best calculate the amount of days that intersect between two date ranges?
View 4 RepliesI have to insert YEAR WEEKNUMBER STARTDATE ENDDATE values to a datatable( say weekrange). If I pass 2011 as year
WEEK RANGE STARTS FROM '2011-03-28 ' TO '2011-04-03'.(Because in my database 2010 last week range endds with '2011-03-27')
Like this I have to generate for 52 weeks.
I want to write a stored procedure, that takes only year as parameter. with this year I have to generate week ranges and insert into my table as shown above.
have two text boxes then the second textbox is not allow the greater than first textbox value . how i can do this.
View 2 RepliesI remember seeing an example explaining how you could setup the asp.net chart control to show two sets of data from different date ranges on the same chart, but I can't find it now that i need it.It showed sales for Jan, Feb Mar 2009 in one series and sales for Jan, Feb, Mar 2008 in another series and had the chart in 3D so that one series was in front of another.Does anyone know of such an example or have any pointers how to achieve it?
View 1 Repliesi am working on an availability / booking system, one element in the form will be a dropdownlist control with a selection of date ranges for a customer to select the period they want to book.these will be a list of ranges for each week (monday - sunday)eg
27th Sep - 3rd Oct 2010
4th Oct - 10th Oct 2010
11th Oct - 17th Oct 2010
etc
is there an way to populate this dropdownlist dynamically from a calendar or date function so it can cater for dates up to 18 months ahead?i dont really want to populate it from database entries or hard coded list items if there is a less laborious way.
EXAMPLE :if i add a range {1,10}and another range{15,20}i should get a message saying the ranges from 11 to 14 are missing.
View 3 RepliesIn a vb.net application I have a set of integers currently stored in multiple Arraylist (But this could be something different if required)
al1 = {1, 2, 3, 6, 7, 9}
al2 = {2, 3, 4, 9}
al3 = {2, 3, 19}
I would like to get the set {2, 3}
I thought about using LINQ to join the list, but the number of Arraylist can change. I know I can always loop through everything and check if an integer exsist and keep track of it, but I thought there might be an easier way?
I have class called GroupSelect and made a collection List(Of GroupSelect)().
Now I need find to RowNo = 4 in List(Of GroupSelect)() and get GroupSelect object.
Public Class GroupSelect
Public Property RowNo() As Integer
Get
Return m_RowNo
End Get
Set(ByVal value As Integer)
m_RowNo = value
End Set
End Property
Private m_RowNo As Integer
Public Property GroupNo() As Integer
Get
Return m_GroupNo
End Get
Set(ByVal value As Integer)
m_GroupNo = value
End Set
End Property
Private m_GroupNo As Integer
End Class
I have a SQL database with a table storing three collums. ClientID, StartRange, EndRange.The user needs to add records to a different table - the number being inputted by the user eeds to fall in the range where it is equal to the client he is adding if for. There can be a number of different ranges for a client which where I am falling over, it would be easier if it was just the one range!What is the best way to check this- I was thinking a customer validator method in the code behind?Would I need a Stored Proceedure? or some DataSet Tables and some how parse the ranges?
View 13 RepliesI'm trying to define the parameters of my data source using a stored procedure. My Stored Procedure Syntax is perfect and i'm happy with that, i've just got trouble with connecting my parameters to my controls. I have 19 Parameters, of which i've managed to connect 17 to controls within my ASP.Net form (some to text boxes, some to ddls etc...)
However, i'm trying to connect a particular parameter to a control, but when i drop down my list of controls it's not visible? The control is within a hidden panel so i've un-hidden it and it's still not there. I've even commented out the panel and tried that but i can't find this control! I just cant seem to get this control to appear in the list.
Has any one seen anything like this before at all?
I have anywhere from 5 to 10 generic list in an ASP.NET VB.NET web app. I would like to write a method to pass them all into, and return only the elements they all have in common.
View 2 RepliesI have an issue with the appearance of my reorder list. The draghandle div is outside of the item template div. I have used the reorder list in the past and the draghandle was always inside of the item template. I can't seem to find any mistakes so is this a bug or do I have a mistake somewhere. All other functionality works great. Here is the code.
[Code]....
i want to find control radio button list i have child control as listitem at runat server,i have id like i have 4 option e.g.option1,option2,option3,option4 i want to selected one of them.
View 2 RepliesHow to filter Max or min value from gridview data which is bind with sql datasource.
Like I give date range from and to all the data popup in gridview then I have dropdown with 2 values Max and Min. If i select max so max value from payment column gridview shows and if I select min so min values from payment column shows.
I would like to find a way of running custom validation on a checkbox list. The reason why is because they were a radiobutton list. Then our client decided they wanted to be able to uncheck them (without a clear button) so in the end I had to change them to checkbox lists and make them mutually exclusive. On some of them, one must be selected and I downloaded this: [URL] to set them as required - worked nicely. Perhaps there's a way of building on this further to create some sort of custom checkbox validation. why I need this custom validation is because when the built form checkbox list = flat or maisonette then floor level is then required.
View 3 RepliesAs I iterate through a DataTable object, I need to check each of its DataRow objects against the items in a generic string List. I found a blog post using the List's Find method along with a delegate, but whereas that example has a separate class (Person), I'm attempting something like the following using an instance of the string object:
// My definition of the List object.
List<string> lstAccountNumbers = new List<string>();
...
// I populate the List via its Add method.
...
foreach (DataRow drCurrentRow in dtMyDataTable.Rows)
{
if (lstAccounts.Find(delegate(string sAccountNumber) { return sAccountNumber == drCurrentRow["AccountNumber"]; })
{
Found_DoSomething();
}
else
{
NotFound_DoSomethingElse();
}
}
However, with this syntax I'm receiving "Cannot implicitly convert type 'string' to 'bool'" for the if block. what I'm doing wrong and how best to accomplish what I'm trying to do?
I know to code to a specific event, you'll have to select the control and select the event in the event button with an image of a lightning bolt near the properties window, but I cant seem to find the event list for the web page..like the pre render, load..etc.
View 6 Replies I use EF 4 and Membership Provider Shipped with ASP.Net 4.0.
I need find all Users in a Specific Role and Populate a DropDownList using List<ListItem>.
DataBase Tables involved are:
[code]....
Problems:
IF return FALSE always, so I am not able to populate List<>.
I suppose I am doing wrong in if an some Properties.
How find out time duration in asp.net using drop down list Control? Result will display in textbox.
View 13 RepliesI am new to ASP.NET and i have created a page where i am calling Fullname of person in Checkboxlist. When a user selects some names and clicks sendmail button , it should go into sql find out the email addresses of selected names and convert them to a mailto:aaa@ymail.com;abc@gmail.com; ask the user whichever mailaccount the user wants to use to send the mail to them.
View 4 Replies
