I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day.
That code looked like this:
Public Class Form1
Dim ReturnValue As Object = Nothing
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day.That code looked like this:
Public Class Form1
Dim ReturnValue As Object = Nothing
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String
[code]....
I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day. That code looked like this:
Code:
Public Class Form1
Dim ReturnValue As Object = Nothing
[code]....
Code:"select payrolldate from payroll where(payrolldate <= getdate())and payrollran <> 'yes'")but when I add that query it just returns a value of 1/1/000 as the date.
I am developing an application that based on when a user has last entered a payroll, my program tells them the next available Sunday that is available to them based on
1. The date that the last time payroll was entered
2. If payroll ran = "yes" or "no"
I have a sql query that returns the next Sunday back to me based on this criteria, but when I put it into my application, it returns 1/1/0001 to me.
Here is the query:
select MAX(payrolldate) AS [payrolldate],
dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7, '17530107') AS [Sunday]
from payroll
[Code].....
I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day.That code looked like this:
Public Class Form1
Dim ReturnValue As Object = Nothing
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String
[code]....
"select payrolldate from payroll where(payrolldate <= getdate())and payrollran <> 'yes'")but when I add that query it just returns a value of 1/1/0001 as the date.
Anyone know how I can return 3.0790 given the two dates below using VB.NET 4?The code below returns a whole number 3... Dim datTim1 AsDate = #1/31/2005# Dim datTim2 AsDate = #2/29/2008# Dim YEARS AsDouble = DateDiff(DateInterval.Year, datTim1, datTim2) MessageBox.Show("Years: " & YEARS)
View 8 RepliesI have made a simple program in VB.Net.In this program I made two DataTimePicker with the names of
1. DtpFrom
2. DtpTo
I want to get the dates from tblStudents between the dates given in the dtpFrom and dtpTo.The Date Format for these two DateTimePicker and in tblStudents is "M/d/yyyy".When I run this query.
"Select AdDate from tblStudents where AdDate >= '" & Format(dtpFrom.value,"M/d/yyyy") & "' and AdDate <= '" & dtpTo & it gives me some times correct results but some times it missed some of the dates. I want to get the precised dates, without missing any date. So is there any Mechanism to solve this Problem.
I am messed up with the below query[code]...
but when i run the query in my project the reader in not reading correctly...even if values are present is returns false and if values are not there then it returns true.
I'm trying to query a remote machine and get the cpu percentage similar to task manager.. I have the following code:
Code:
im wmiK As New WMI
Private objMgmt As ManagementObject
[code].....
I have the follow Linq query that is in a web application that was converted from .NET 1.1 to 3.5:
dim objListOfFilteredDataRows = from datarows as datarow in objDataSet.tables(0).rows _
where datarows("SomeColumn") = SomeValue
I have the exact same query in an application that was created using .NET 3.5 and the query returns an IEnumerable. However the query in the converted application is returning:
{Name = "WhereEnumerableIterator`1" FullName = "System.Linq.Enumerable+WhereEnumerableIterator`1[[System.Data.DataRow, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]"}
**Edit: When I highlight the expression, the intellisense says that it doesn't know the type of objListOfFilteredDataRows and assumes its a type of "Object". Why is the type not infered in the converted 1.1 application but is infered in the "native" 3.5?**
What am I missing here? How do I convert the "WhereEnumeratorIterator`1 to an IEnumerable?
I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:
Gender.Current Occupancy < Max Occupancy Available Flag is Checked I know this should return results but it keeps returning an empty set.Code is below
[code]...
UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.
I have a database application connected to a sql express datafile, i am using a datagridview and have clicked on the arrow and added a query. the query is simply sort / ascending on my date field which is a text field with auto generated when the field is focused so i know the dates are entered correctly but when i use the query they are not in their correct order. [Code]
View 10 RepliesJust a quick question about LINQ, I want to use a value from the returned dataset to lookup a value and return this. The line I am struggling with is .ViewingNotes = NewViewing(pt.ProspectId).GetViewings().Columns(7).ToString(). Is this possible?
With BusinessLayerObjectManager.Context
Return (From p As [Property] In .PropertySet
Join pt As Prospect In .Prospects On pt.Property.propertyID Equals p.propertyID
[code].....
I'm doing some XLINQ in VB for work. I basically need to pull some values from a small chunk of XML as listed here:
<?xml version="1.0" encoding="utf-8"?>
<Fields>
<typeQtyRadioButtonList>1</typeQtyRadioButtonList>
<cmbQtyCheck>Reject</cmbQtyCheck>
[code]....
... Leaving out the implementation of the For Each loop....So I have stuck a break point on the for each and the collection has no elements in it.
I'm trying to run a query from a search form by date and I'm receiving the following error:[Teradata Database] Partial string matching requires character operands.The code for the search is:
ElseIf OptDate.Checked = True Then
sSQL &= "DATE_SUBMIT Like ('" & txtDateRec1.Text & "%')"
End If
I am trying to debug my code, which involves a simple webservice that passes parameters to a data class, which calls a stored proc, and returns one row of record. I am not getting any error messages, but I am not getting any records back either.[code]
View 1 RepliesWhen I'm trying to run this program Sql QUERY doesn't work properly , but the month and day are okay but it comes to year it doesn't work...
Dim strSql As String = "SELECT * FROM tblAudit WHERE Date_Time BETWEEN '" & Format(dtpFROM_F.Value, "MM/dd/yyyy") & "' AND '" & Format(dtpTO_F.Value, "MM/dd/yyyy") & "'"
classLibrary = New ConLib
classLibrary.openConnection(strConnection)
lblconstat.Text = DatabaseStatus
If Not classLibrary.isconnectionopen() Then
Exit Sub
End If
classLibrary.initializeCommand(strSql)
Trying to work out if there's a nice way of doing this, preferably in Linq rather than loops, which is what I've done for now.
I want the number of days my Product is active between two dates.
Product has many ProductHistories, ProductHistory has values for DateActive and DateInactive. DateInactive can be null, and often will be, to show that this history is ongoing. Histories won't overlap.
I want to sum the maximum of my startDate or the ProductHistory's DateActive, and subtract that total from the sum of the minimum of endDate or ProductHistory's DateInactive (endDate by default if DateInactive has no value).
Worked example:
Get active number of active days between 2011-01-01 (1st Jan) and 2011-02-01 (1st Feb)
Histories:
Active 2010-12-25 : Inactive 2011-01-05
Active 2011-01-15 : Inactive 2011-01-20
Active 2011-01-25 : Inactive null
[Code]....
I have a view on some data in my database it returns the data as I would expect, for example
Call Date To From Phone Number
20/1/2010 00:00 23:59 08923233223
20/1/2010 00:00 23:59 08923233245
However when I have added this to my Entity Model and query it I get duplicate(and unexpected) data appearing
Call Date To From Phone Number
20/1/2010 00:00 23:59 08923233223
20/1/2010 00:00 23:59 08923233223
I am simply binding a Entity Data Source to this Entity but I am left scratching my head as to why the data is being returned differently
EDIT: Interestingly this can't be the result of some strange under the hood join as the row counts match as expected. I have also put together a query myself to test with the same odd results.From o In App.Entities.v_PersonalRules Where o.companyid = CompanyID Select o. I am using Visual Studio 2010, .NET 4
EDIT: The front end code is fairly simple
<asp:EntityDataSource ID="EDS_Personal" runat="server" ConnectionString="name=Entities_NEW"
DefaultContainerName="Entities_NEW" EnableDelete="True" EnableInsert="False"
EnableUpdate="True" EntitySetName="v_PersonalRules" EntityTypeFilter="v_PersonalRules" >[code]....
Im currently working on an n-layer application that does alot of database work.90% of all database queries are updates, and inserts and I want to be able to view the results of my query in the presentation layer.I was thinking of creating a QueryResult class that has a few properties like QuerySuccessful (boolean), Message (string) - holds success or error message, and optional field to hold any additional data that may need to be passed back to the presentation layer.So I guess my question is, am I going about this the correct way by creating a QueryResult class, and passing that back up through the layers to my PL?
View 2 RepliesI have an installment payment program which have Hijri date (Saudi Arabia) and I already have the code for it's converter inside the forms (using datetimepicker for the Gregorian & maskedtextbox for the Hijri). I'd like to know how can I convert or produce the corresponding equivalent Hijri dates of a series of Gregorian dates generated in my table? I am using SQL query for this. This triggers when I click my Save button for the computation of the premium terms of the customer having an installment payment plan for an item boughtIs there an SQL query to convert Gregorian dates saved into Hijri dates to an Access table?By the way, I am not using any SQL server or Oracle,
View 3 RepliesI need to add a gridview to my page where the sqldatasource is based on a query that returns records that fall between Sunday and Saturday of the current week. (Each record has one date field) The records are for payroll purposes and the payroll week runs from Sunday to Saturday. I need to find all records that fall in the current pay week.
View 2 RepliesI have got an xml document which looks something like this.
<Root>
<Info>
</Info>
<Info>
[Code]...
How can i write a linqToXML query so that it returns me an IEnumerable containing each child element, in this case all five child elements of , so that i could iterate over them. The order of child elements is not definite, neither is number of times the may appear.
In my code I enter a string in a text box and have the query check the server for the entry. If it exists it returns the string and the date into two separate variables. The database only has TrackingNumber and Date. Below is the code. As of right now i get "Invalid attempt to read when no data is present." at the "If (sdr("TrackingNumber") IsNot Nothing) Then" line.
Public Function CreateSqlParameter(ByVal name As String, ByVal dbType As DbType, ByVal direction As ParameterDirection, ByVal value As Object) As SqlParameter
Dim parameter As SqlParameter = New SqlParameter()
[Code]....
i need the code too check the files in the debug folder and if there is already a file with 0001.txt file i want the code to make a new file called 0002.txt file.
[code]...
I keep getting this error: Creating an instance of the COM component with CLSID {6D7AE628-FF41-4CD3-91DD-34825BB1A251} from the IClassFactory failed due to the following error: 80010001.
We think it has to do with the fact that we are on company computers that have limited access. If that is the problem, is there a way around it?
DateTime: what do you use when you need to record Datetimes back in the time before 0001 A.D. (C.E.)
View 11 RepliesI have an ASP.NET web application (VB.NET) using an Oracle database. On an insert, I need to get the identity of the inserted row back. I am trying to use RETURNING, but I keep getting a value of 1 returned.
Dim strInsert As String = "INSERT INTO L.TRANSACTIONS (LOCATION_KEY, TRANS_CREATOR, TRANS_EMAIL, TRANS_PHONE) VALUES (:location_key, :trans_creator, :trans_email, :trans_phone) RETURNING TRANS_ID INTO :ukey"
[Code].....
I have two dates. [code] How to print all dates between these two dates in one listbox, for example: [code]
View 8 RepliesSay the user specifies these two dates....
Start Date: 2010-12-05
End Date: 2011-01-15
If I select December 2010 I should get the folllowing
startdate = 2010-12-05
enddate = 2010-12-31
Select January 2011 then
startdate = 2011-01-01
enddate = 2011-01-15
Should I subtract dates? How can I get the start and enddate for the current month/year based on the overall start and end date.I'm coding in vb.net.
