I have a small problem with the SQL statement that returns the information from an Access 2003 table based on the dates input by the user. IT works fine if I manually code the dates as below:
Code:Dim da As New OleDb.OleDbDataAdapter("Select * From Sanctions Where [Date] BETWEEN #01/04/2009# AND #30/04/2009# AND [Group] Like '%EN%' AND [Description] <> 'Merits' ", cnDept) but if I try to put ther variables in the statement like:
Code:Dim da As New OleDb.OleDbDataAdapter("Select * From Sanctions Where [Group] Like '%EN%' AND [Date] BETWEEN # SDate # AND # FDate # AND [Description] <> 'Merits' ", cnDept) it returns a syntax error.
I am having a problem selecting dates in my application.The Windows form has a datetimepicker control with a datagridview to display the selected data.The Code for the Form is below.The Data table 'vehicle' has the following data:
ID = 1 DateIn = 28/11/2011 5:00:45 PM Vehicle = ABC4567 ID = 2
i have a data base where i am selecting rows between two dates, but what i need to do is also get another another row if it has the same ID so: If i put the date as: 01/02/2011 - 01/02/2011
I'm using two datetimepicker controls to set the start and end dates for a range of dates I'm searching for.I want to make sure that the start date selected is not greater than the end date. This code works, but it runs the messagebox prompt twice for some reason. I've tried to ignore it from doing this, but it's not working. Can someone tell me what's wrong?
Private Sub dtpStart_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dtpStart.ValueChanged
I have one more problem with MonthControl.And when I bold some dates the program doesn't show bold dates on month calendar.When I move on next or previous month and get back to currently month the program normal displays bold dates. What's the problem?
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
I have code, shown below, that works all except for 1 thing: The variables being passed byRef get passed, but once modified in the else section of the "if me.invokerequired" code of RecordData, the variables are never updated in the calling function. To reiterate, the calling function does not receive the updated data that is in the variables custid and amt.When debugging, I see the data change in the else section of "if me.invokerequired", but once it returns from the callback the data is missing.[code]
I define some global variables of a class as follows:
Private Class MyClass Private var1 as Decimal Private list1 as List(Of string)[code].....
But I found that after this form is closed, all above variables, var1, list1, list2 still exist in memory. I thought they should be collected by gc since the form is already disposed as I confirmed.
Add: I have monitored half an hour after the form is closed. But these variables are not collected by gc. I have an automatic update procedure on the form which uses above variables.Since the above variables still hold values, the automatic update procedure is always called which causes exception. (One quick fix is to check if form.isDisposed in update procedure. But I do not think this is elegeant. Besides, these variables occupy memory.)
Does the memory used in declaring variables are reclaimed by the OS when these variables go out of scope?Does the memory used be released by setting thier value to nothing? if not, then how can I force the garbage collector to run or excecute at a certain/desired time..How about in Windows Forms..How can we make sure that the memory used in initializing and showing forms be released if those forms were closed?
Question 1: What is the difference between "Background Worker" and "Worker Pool" as indicated within the MSDN samples provided.
Question 2: I noticed while using, AddressOf _Function_, variables cannot be passed; what would be an efficient solution to this?
Question 3: While using multithreading is it required to invoke before setting variables, or only form properties?
Question 4: While using System.Net.Sockets is it safe/efficient to use Application.DoEvents while waiting for new data; or would be using a Do While loop be fine without DoEvents since the action would be multithreaded? Note: there can be up to 2000-3000 sockets in use at a time.
I'm new in .NET programming.I have a class Form1 that includes Button1_Click event.Button1_Click creates a multiple Text Boxies at run time)Here is the class:
Public Class Form1 Dim shiftDown As Integer Dim counter As Integer
Basically, I have a list of dates in a SQL table with some statistics next to each of them. I want to compare the dates in the table with a certain date I choose. However, my dates in my table are stored as Varchar(50) (and have to be). Apparently I can convert the date in the table into date type but I don't know. Does anyone know how? My current code can be seen below.
I have a order item form with a datagrid I want to add dates to different rows i.e. if the 1st row i order a cheese sandwich in that row I am able to insert a date in the correct cell. I want to be able to insert dates in the other rows with different order items. I have this code below and I want to do a loop back for it. [Code]
We would like to compare a date from the db with current date. Here is what I have tried so far: 'Obtain current date Dim curdate As String = Now.ToString("yyyy") 'Now compare curdate with date from db called eventdate. Event date is of dateTime datatype. If drv("eventdate").ToString = "" And Year(drv("eventdate").ToString) = curdate Then
I am trying to get back a single from from a EF database model using the below line of code..
Dim _classRoom As classrm = db.classrms.Select(Function(b) b.Course_ID = _CurrCourse.course_ref)
Where classrm is the name of the entity and db is declared as a new entity. What I am trying to do is select a row from the entity based on matching Course_ID which in this model is a string. So that I can later use the variable _classRoom to get other items out of the same row.. However I am getting the following error:
Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[System.Boolean]' to type 'Trial_Online.classrm'.
I have to preform similar tasks with several different Entities but if I get pointed in the right direction I can manage from there...
Using a checkboxlist not a simple checkbox I need to select 1 checkbox otherwise display a error message in an label once I submit the form. My checkboxlist does generate correctly now I just need to validate it
'check checkboxlist For Each ckbox In checkBoxCropsFertilzed.Items If ckbox.Selected > 1 Then lblErrorMessage.Text = "too many selected" End If Next
I'm having some trouble. I have an sql statement to update some rows to an Access DB I enter a date like 01/08/2009 (1st Aug 2009) and it saves to my DB as 08/01/2009 (08th Aug 2009 but still 01 Aug if it were mm/dd/yyyy format)
I am trying to find the difference between two dates. The first of the two dates can be changed and when it is changed, the difference between the original dates has to be retained. This means that I have to automatically change the second date to have the same difference in days as it did before, but with a new first date. [code]I have the value of the old date1(currDate) and the new date1 value(newDate). I need to get the difference between these, and then add or minus these days from the endDate.
i have two DatePickers on form and I want filter between two dates. So when i click search in lsitview display the dates between can anyone tell me how to deal with?
ive got several combo boxs on a search form and its all working great if you select the items from the list, but have a problem if you type the value, the selectedvalue isnt being returned what do i need to do, this is what im using to get the value when selecting via clicking
Private Sub BTYPE_ComboBox_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTYPE_ComboBox.SelectedIndexChanged If Len(Trim(BTYPE_ComboBox.Text)) > 0 Then BTYPE_FILTER.Text = BTYPE_ComboBox.SelectedValue.ToString Else BTYPE_FILTER.Text = 0 End Sub
I have 2 textboxes, txtStartDate.Text and txtEndDate.Text, user choose date through calendar date picker. Now I want to count the days between the two selected date and save the result in the database field totalDay(type integer), the following is my code: But when I click button and try to save it into database, I receive this error: The version of SQL Server in use does not support datatype 'time'.
how come when I retrieve my data from SQL my date field returns the date along with a time of 12:00:00 AM???? The Sql BD Type is Date and it is a date only in the SqlDB. I'm populating the date into a textbox.
Can anyone reccommend a good database that I can use on a local machine to storenames/addresses etc. and that integrates easily into .Net 2.0.I have used MySQL a fair bit, so something along that route would be great but without the need to install additional software on the computer or connect externally to a server
I wrote some software that use the AVICAP32.dll to do a spot of video capture.All was going well till they went and bought a laptop with a built in webcam.Now my software picks one a random and uses that for the video (somewhat annoying to say the least) Can anyone tell me how to pick a camera to use,I suspect it is related to DVM_DIALOG but my experiments have not been too successful.
I Have a problem with selecting a row in a datagridview. I want the user to press on the data rowheader of the data gridview of a particular row and then that rows first item are put in a string. But the problem is that if i Select an item another item is still selected. So If I press the mouse button on the row header the previous item is still selected and then the wrong data is in the string. Here is the code under the event of the datagridview mouse click:
Private Sub dataGridView1_MouseDown(ByVal sender As Object, ByVal e As MouseEventArgs) Handles DataGridView1.MouseDown Dim hit As DataGridView.HitTestInfo = DataGridView1.HitTest(e.X, e.Y) Dim index As Integer
