Asp.net - Select A Variable TimeSpan With An Arbitrary End Point
Apr 29, 2009
I've been working on a Stored Procedure that checks the time, then retrieves records going back over the last full 24 hour period between 8am and the previous 8am. So, for instance, assume that it's currently 10am. The stored procedure looks at the current time, notes that it is past 8am, and sets the query to run backwards 24 hours, from 8am today to 8a yesterday. If it were, say, 7am, the query would be set to check from 8am yesterday to 8am the day before. This was actually relatively simple to do. The SP is meant to be used to retrieve records for a report tracking jobs completed in the given time span.
However, they've come back at me and asked me to change the stored procedure such that the hour the report ends at, and the span of time checked, is configurable from the front-end of the site. I have this working for TimeSpans greater or equal to 24 hours, but am having trouble with spans under that. Here's what I have so far for my logic in the Stored Procedure -
-- Retrieves data on jobs that completed/completed with errors during a given time span.
DECLARE @Hour NVARCHAR(2)
DECLARE @TimeFrame NVARCHAR(2)
[Code].....
View 2 Replies
ADVERTISEMENT
May 24, 2010
I want to know if its possible to loop in a variable and grab info from point a to point b
This is what I have stored in my Variable
PHP
</div> <!-- div reviews end white-space:nowrap; margin-bottom:5px; class="reviews" -->
<div class="list_address">
[Code].....
View 11 Replies
Dec 9, 2009
These two TimeSpan are stored in the Database with 24hr format. No date, only TimeSpan.
Dim r As TimeSpan
Dim tsStart As TimeSpan
Dim tsEnd As TimeSpan
[Code]...
Is there any TimeSpan method to get this right?
View 3 Replies
Apr 26, 2010
I have a requirement that regardless of the start and dates that I need to loop through that timespan and calculate figures at the month level. I cannot seem to figure it out, and maybe it is not possible, but I would like to do something like:
FOREACH Month As TimeSpan in ContractRange.Months
Do Calculations (Month.Start, Month.End)
NEXT
Is this possible or do I need to calculate the number of months, and just iterate through the amount of months and calculate the start/end of that month based on my index?
View 2 Replies
Sep 21, 2010
I was wondering if there was anyway for me to get the string value of a point variable so that I can compare it. I tried to do something like:
DirectCast("point" & number, Point).ToString
View 7 Replies
Nov 15, 2010
I am thinking is to have a question, then between 2-4 answers, and depending on the answer a point value gets assigned to a variable, but then when that one question is answered you can click a button that moves to a next page type of thing with a new question on it. I think I could probably figure most of this out but when it comes to switching to a different question I am not sure how I would do that.
View 11 Replies
Jun 4, 2009
I hve been working with points a lot recently, and I have been wondering if there is a way to set a point without setting point.x and point.y separately. For example for (3, 5): Point1 = (3, 5) But that isn't right
View 4 Replies
Oct 21, 2010
I know there's the old, late-bound, VB6 Collections, but I was looking for something like Generics, but either without having to specify the type at compile time, OR finding a clever way to allow the code to determine the type on its own and then call some generic class.Why? I'm bored, and I thought it'd be fun to try and implement my own library for NBT, or NamedBinaryTag.It's the storage format used in the popular Minecraft game.url...I know there are existing implementations out there, but there's no point in copying those if I'm doing this solely as a learning experience to get a better grasp on file streams, byte arrays, endian conversion, and general .NET stuff (I used to fiddle with VB6/VBA a lot, so .NET is a huge change).
What's hanging me up is TAG_Compound. Per that specification, it's essentially a collection of objects of any other Tag type, including additional, nested TAG_Compounds. You can do some freaky nesting/recursion with this kind of a format.I've got a rough outline in my head of how to do the other classes, but the storage of arbitrary types is just making me draw a blank on how to store that in a stub class (clsTagCompound) So that a generic class (clsNBT(Of T)) can use generic functions to access the payload.List(Of T) looks like it could work if I could feed it a common interface. But since a Generic class will be the main component used, its interface is also generic, and that just leads to nasty generics chain (List(Of (clsNBT(Of XXX))).[code]What I'm thinking of doing, is making all derived classes implement INbt(Of T).For clsTagCompound, its SetPayload method will start walking a bytestream after the compound's name field is parsed. For each new TagType that it encounters, it would theoretically call DirectCast on a temp variable Dim'ed to INbt(Of T) to convert it to the class defining that particular TagType.But this doesn't seem to work as planned. I believe my Catch 22 is that to even use clsTagCompound, I still have to define T, and that's where I get stuck again. I somehow need to create an interface that is NOT generic, yet can be applied to all the classes for the various Tag types and still call their GetPayload function to return the payload specific to a particular tag.
View 4 Replies
Jan 19, 2009
Is it possible to have a class, sub or function declared with an arbitrary number of parameters? And those parameters be a type, like generics? For example
vb.net
Public Class Test (Of T1, (Of T2))'The (Of T2) means that after the first parameter can be an arbitrary number of parameters
[Code]....
View 9 Replies
Aug 27, 2010
You can set listview items in a-z order and z-a order but how to set listview items in arbitrary order?
View 4 Replies
Feb 14, 2011
I have a Diagonal line drawn on a picture box on my forum and i need to know if the user has clicked the line I have the Start point and End Point of the Line and the mouse x,y location So i basically need to find out if the x,y of the mouse is on the line.
View 2 Replies
Sep 28, 2011
The three labels "Floor" "Typ." "HeadsI can insert once fine but multiple times only the third instance is written to the form.I have 2 textboxes to test that the Label.Name is changed but I can't make the Label.text stand for each label. I am certain this will occur too with the textboxes.I also need to keep track of these boxes for further use with the program.
Public Class Form1
Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
[code]....
View 1 Replies
Mar 2, 2011
I have a generic list, like this:
System.Collections.Generic.List<Question> myquestions = new System.Collections.Generic.List<Question>();
And I have a paging example, using a LINQ table acquried from database, doing this for paging:
var questions = context.Questions
.OrderBy(sidx + " " + sord)
.Skip(pageIndex * pageSize)
.Take(pageSize);
Right now, for paging my populated from code list, I have:
var questionss = myquestions
.OrderBy(x => x.Id)
.Skip(pageIndex * pageSize)
.Take(pageSize);
And what I want is being able to order "myquestions" by a string as in the above example. Is that possible?
View 5 Replies
Jul 3, 2010
I'm trying to write some of my own linear algebra methods, and I'd like them to work independent of the number of dimensions of the array. However, there doesn't seem to be any generic method, that I can see, for looking up a particular element in an array of arbitrary size. I mean I could write code to find the rank and then use (), (,), (,,), (,,,), etc, but that seems rather cumbersome.
View 4 Replies
Jul 12, 2009
How do you add an arbitrary number of controls to a form at run time? With indexed controls I could define the 'seed' control at design time and reference 'clones' of the 'seed' control at run time via the index. Now I must declare each additional instance of the control at run time then set each individual property that differs from the default for that control for each instance. Then I must add the newly declared control to the appropriate container controls collection. I'd like to do this in a loop but how can I get away from using a fixed control name in the declaration:
Dim controlname As New Control
I can't use a string that I can manipulate the contents of for controlname because it sees it as a double declaration. I can't use an array such as Control(index) for controlname. Dim Control(maxindex) As New Control doesn't work. Dim Control(maxindex) As Control works but any assignment based on this such as Control(indexvalue).Name = "ControlName" fails. It didn't address the issue of handling the declaration of new controls in a loop with some kind of variable name for the control.
View 1 Replies
Oct 21, 2009
I need to do maths on both floats and integers with much bigger accuracies and magnitudes than offered both by int/float/double in .net. I recall there was something like that for c/c++.
View 2 Replies
Dec 31, 2010
I'm trying to extract a piece of text from within the string, defining both a starting point and an ending point. For instance, say I want to search for the text found between "That is a " and " car" in the string "That is a red car", so it would return "red".I know you can use .SelectionStart and SelectionLength, but the length of the word can change, so the selection length can vary. What I want is to establish a specific starting point and a specific ending point from which to extract the text from the string.
View 5 Replies
Sep 14, 2009
working with: ASP.net using VB.net connecting to MS SQL Server
What I'm trying to do is take the result of a SQL select query and place that in a string variable so it can be used in things like a textbox or label. code so far that doesn't work...
Imports System.Data.SqlClient
Partial Class dev_Default
Inherits System.Web.UI.Page
Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs)
[Code].....
View 3 Replies
Nov 6, 2011
I have a case where my enumeration is like this:
Public Const PREVIEWCREATE As Integer = -3
Public Const SETUP As Integer = -2
Public Const PREVIEW As Integer = -1
I then have a form post where i recover a string like:
Dim mode_custom_mode = request.Form("custom_mode")
I can do
Select Case UCase(mode_custom_mode)
Case "PREVIEWCREATE"
[Code].....
is there a more direct way in VB to do something like:
t.StartupModeId = StartupMode.(mode_custom_mode) ?????
View 2 Replies
Apr 8, 2011
I am having an issue with the following code. It works when the data is all numeric such as 9200000 but not when the data is alpah numeric such as b101462 I am collecting data from a textbox into a string variable findacct and then using the variable in the sql statement. The data in the access database is char type.
The following select statement works when all the data is numeric for the find acct varialbe but if start with a alpha char like B101462 it gives me a missing parameter error."Select * From purchase where issuedate >= " & "#" & finddate & "#" & "and account like " & findacct)The following statement works when I actually put the account info in the select statement and do not use a variable."Select * From purchase where issuedate >= " & "#" & finddate & "#" & "and account like 'b101462'")
View 4 Replies
Apr 16, 2009
I want to select a table on my database but I have the name of the table on a variable.Because I will create tables periodically I have don't know the name of the future tables so I will stored on a variable. The problem is how I call the variable on SQL statment. I made a code using the addwithvalue to use the variable on the SQL but didn't work. Here is my code
Dim tablename As String
tablename = InputBox("Enter the table name")
Dim myconecction As String
[code].....
View 3 Replies
Aug 16, 2011
I have a simple vb script which extracts some data from our accounting software to a text file. It works fine when I do not use a variable in my select statment as follows:
xselect = "SELECT SourceJournal,JournalRegisterNo, PostingDate, PostingComment,UserCreatedKey
FROM GL_DetailPosting
[Code].....
View 4 Replies
Jul 29, 2009
i have a picturebox which displays a map i have 2 modes add point and delete point when the user clicks the picture it creates a point on the picture where the user has clicked that works perfectly its when i try and delete the point when it doesent work :/ i have all the points loading from an xml file this is the code i have:
[Code]...
basicly i want it to when the user clicks the point it fines the x any y in the xml delete the node then delete all the points on the map then reload them all according to the xml
View 9 Replies
Mar 27, 2012
I'm working on a function that handles events from a number of buttons and trying to define a Select...Case based on the clicked button. Something like this...
Private Sub btnClick(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles btnThis.Click, _
btnThat.Click, _
[Code]....
which don't work either. Is there any way I can define a Select...Case in this manner or is it always destined to fail due to the attempt at comparison of reference types?
View 3 Replies
Mar 30, 2009
How do I fill the variable in my SELECT statement?
Private Sub TabPage2_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles TabPage2.Enter
strTenantPin = tbxTenInfo_Pin.Text
[Code].....
View 4 Replies
Aug 14, 2009
I have several instances of one form loaded. They all have an instantiated variable "Name." How do I select one of these forms based on the name variable?
Code:
Public Sub MakeForms()
Dim x as New frmBlack(me)
x.show
End Sub
View 3 Replies
Jun 11, 2011
I am using VS 2010, SQL 2008 express and doing windows applicaion programming in vb.net.I want to write a select query(or Stored Procedure) such that the conditions mentioned under WHERE clause can be variable .like :Select * from TABLE where F1 = var1 and F2 = var2 and F3 = var3.Now on the basis of some conditons the equations in where clause should beused.Say condition is variable value >6.Now in this case ,if
var1 =7 var2 =3 var3 = 8 then the query shud behave like
:
select * from TABLE where F1 = var1 and F3 = var3
[code].....
View 1 Replies
Apr 1, 2011
I'm trying to retrieve values using vb.net from a sql database. How do I use "SqlDataSource.Select()"? Is there a way to move the value to a variable that I can use for other things? I know its kind of scattered and vague but that is the best I can do. I basically need to set a labels text to a value in a table.
View 2 Replies
Mar 19, 2012
I have 10 checkboxes on my screen. I have a variable setup called "case" as a string. I want to know how I can say:
If checkbox1 is checked then case would be equal to "this".
If checkbox2 is checked then case would = "that"
Example of something I tried to cook up but didn't work because it tells me that I can't only use this in a "select case".
Dim Case as string
If checkbox1.checked = true
case = test1
end if
If checkbox2.checked = true
[Code] ......
View 5 Replies
Feb 12, 2011
I am using VS2010 windows application , SQL server 2008 express at backend.I am designing a windows form with fields to search records in database.Say there are 3 fields in the form :
1) material no 2) material group 3)creation date the corressponding table in database with above fields is " Material_master" User can search materials in the database by entering any of the above fields.No I want to write a query where if user doesn't enter anything then my query should work like
"select * from materialmaster "
if only material no is enterd at screen then
"select * from materialmaster where MatNo = materialno "
if both date of creation and material no enterd then
" select * from materialmaster where MatNo = materialno and Date = creationdate "
In other words , field with no values in it should not be accounted in the where clause. Only one query I want to write.How we can achieve this in VB.net windows application?
View 4 Replies
