SQl Query On Form Returning Value Of 1/1/0001
Jun 11, 2011
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].....
View 2 Replies
ADVERTISEMENT
Oct 26, 2010
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]....
View 1 Replies
Oct 27, 2010
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]....
View 5 Replies
Oct 21, 2008
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.
View 1 Replies
Oct 27, 2010
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.
View 39 Replies
Mar 15, 2012
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.
View 10 Replies
Apr 25, 2009
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].....
View 10 Replies
Jan 22, 2010
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?
View 5 Replies
Mar 5, 2011
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.
View 3 Replies
Apr 28, 2011
Just 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].....
View 1 Replies
Jul 20, 2011
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.
View 1 Replies
Jul 26, 2011
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
View 1 Replies
Oct 28, 2010
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 Replies
Jan 4, 2011
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]....
View 2 Replies
Mar 11, 2010
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 Replies
Mar 8, 2010
I 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.
View 1 Replies
Jun 29, 2010
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]....
View 3 Replies
Apr 26, 2011
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]...
View 7 Replies
May 26, 2010
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?
View 2 Replies
Aug 6, 2011
DateTime: what do you use when you need to record Datetimes back in the time before 0001 A.D. (C.E.)
View 11 Replies
Jun 15, 2010
I want to return a value (vbCancel or vbOK) from a form which is shown as a dialog from the calling form.So, I overloaded the showdialog method to return the value.Trouble is, a value of zero is returned as soon as the form is shown.Now, if I can make it behave more like the showDialog method where execution doesn't continue until the form is hidden everything would be fine.
View 3 Replies
Jun 7, 2011
I am trying some Uiculture change functionality.In that I need the name and text of controls in a form to change the culture.I got some Demo project and it is in C#. I tried to make the same functionality with the C#.net and Also using VB.net. But the below mentioned code returns control name with an underscore as prefix. But I don`t want underscore .Code is actually written in Class library.
code is written below
Dim fields As FieldInfo() = form.[GetType]().GetFields(BindingFlags.Instance Or BindingFlags.DeclaredOnly Or BindingFlags.NonPublic)
[code]......
View 1 Replies
Jun 7, 2010
I have a MDI app that I am creating. It, of course, will have multiple MDI child forms. In each child form, I have an options button so that each child form can have it's own set of options. When I click the options button it opens an Options form. This options form is not an MDIChild.
I have a class that contains the child forms options. I pass this class to the options form using a constructor. This is how I call the options form:
Dim dlgPatternOptions As dlgOptions = New dlgOptions(thisPatternOptions)
thisPatternOptions is the class that I am passing to the Options Form.
This works fine and the options form does populate the options correctly. The Options form constructor is this:
Public Sub New(ByRef thePatternOptions As CanvasOptions)
Me.InitializeComponent()
Me.txtCanvasWidth.Text = thePatternOptions.CanvasWidth.ToString
Me.txtCanvasHeight.Text = thePatternOptions.CanvasWidth.ToString
End Sub
I change the options in the options form. How can I get those changes back to the calling form? Do I need to somehow pass a handle of the calling form to the constructor to get the changed values back to the calling form? Is there some way to pass a handle to the options form so that changes made to options will be pushed back to the calling form?
View 2 Replies
Mar 30, 2009
I have a problem which I have tried to solve in several ways, and by searching the Internet for various terms, searching through books and Visual Basic instructional videos, but none have yielded the correct results. My goal is as follows:
1. Create a Database listing job names, job numbers, and a link to the file about the job.
2. Create a form with 2 text boxes, a search button, a box to display results, and a preview panel.
The two above steps have been completed. The following is where I get stuck
3. I want to search for either the job name, and/or the job number, have VB search through the database and return the results in the results box.
4. On clicking on one of the results in the result box, the preview panel will show a preview of the file.
Notes:
i) The files being linked top are Microsoft Excel files.
ii) The box I have used for the results currently is a listbox, though I've no idea if this is the correct choice for what I want to do.
iii) The database I created is an *.xml database created in Visual Basic. I am a fair beginner to VB, learning as I go, but I'm stumped as to how to achieve this so any pointers on how to achieve points 3 or 4
View 2 Replies
Mar 15, 2012
I 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].....
View 2 Replies
Jun 12, 2011
I am trying some Uiculture change functionality. In that I need the name and text of controls in a form to change the culture. I got some Demo project and it is in C#. I tried to make the same functionality with the C#.net and Also using VB.net. But the below mentioned code returns control name with an underscore as prefix. But I don't want underscore. Code is actually written in Class library. It works perfectly in C#.
Code is written below
Dim fields As FieldInfo() = form.[GetType]().GetFields(BindingFlags.Instance Or BindingFlags.DeclaredOnly Or BindingFlags.NonPublic)
View 1 Replies
Dec 12, 2011
My brain may just be fried since it's the end of the semester, but my teacher kicked this back to fix and resubmit...she said that I am "returning the name of your function rather than your variable name".
Here is my code for all 3 forms.
code:
These are forms to calculate the cost of getting a cell phone package.
View 6 Replies
Mar 26, 2008
I am using VB2008 Express and a MSSQL Server 2005 db by the way! I have a comprehensive SQL statement, which should fill my Grid:
DECLARE @Sum NUMERIC(9,2)
SELECT @Sum = SUM(I_LS.lmenge)
FROM dbo.lfs AS I_L
[CODE]...
Now here is my problem! I want to have a form with a datagridview that displays all of the values I am querying. This shouldn't be a problem I guess. However, I have no idea how I can integrate two textboxes that can be used to enter the selection criteria (WHERE I_L.lfsnr LIKE '%1253') AND (l.sped_journal = '11-08')[/SIZE]. I have googled and read many threads so far but didn't stumble upon anything that would suit my needs and answer my question. Maybe it's just too elementary!? By the way, it is very important that the input of textbox1 ((WHERE I_L.lfsnr LIKE '%1253')) is linked to 3 positions in my SQL query to define the search criteria!
The worst thing is that I don't want to have a bindingnav displayed! I do not need any delete, update or add functions just the select option, however!
View 1 Replies
Mar 7, 2011
str = "Select testlib.code, testlib.name, testlib.RATE, testlib.GRP, testlib.lbound, testlib.ubound, testlib.lcode, testlibHEAD.name AS TNAME from testlib, testlibHEAD where testlib.GRP >= '" & frmPrntRate.txtGroup.Text & "' and testlib.GRP <= '" & frmPrntRate.txtGroupTo.Text & "' and testlibHEAD.code=testlib.lcode and testlib.ISMAIN='Y'and testlib.DCODE = '" & frmPrntRate.txtDept.Text & "' order by testlibHEAD.name, testlib.code"
i'm using this query but the value of group n dept are not coming from first form....
View 3 Replies
Aug 19, 2010
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
View 1 Replies
