I m using vb.net with access 2007. I have field with datatype "datetime" and values in format dd/mm/yyyy e.g 8/2/2011. Now I have problem when i fire a query SELECT * FROM tbl_name WHERE tbl_name.datefield= (Select Max(tbl_name.datefield) from tbl_name)); I have some records with dates 11/1/2011 and some records with dates 8/2/2011 but I get wrong result records with date 11/1/2001 instead I want records with date 8/2/2011
View 3 RepliesI have a Form and a Local database and Table1 in DataGridView. Also I have 2 DatetimePickers and a button.
See the photo below: [URL]
The Date column is defined as DateTime datatype.
How to show the records between two dates in DataGridView by pressing button1?
I like to do this with DataGridView Task --> Add Query... --> Query Builder...
i have 2 tables 1 for students and the other for absences and i linked them.i also entered data to absence table..Now i created new form and inserted two date time pickers (dtpFrm ,dtpTo ) and one button to display result as a report using crystal report.
View 7 Repliescmd = New SqlCommand("select * from employee_log where log_datetime >='" + DateTimePicker1.Value.Date + "' And log_datetime<= '" + DateTimePicker2.Value.Date + "'", cn)
Suppose if I select two dates june 21 and june 30 then records between 21 and 30 including 21 and 30 should be shown. But the records of june 30 is not shown..only from 21 to 29 is shown by this code. What should I add or edit to this code?
i have a problem in displaying records between two dates...i have two datetimepickers to choose date from datebase...start date and end date..when i choose start date 1/1/2009 and end date 1/12/2009 then all the records between 1/1/2009 and 1/11/2009....the records of date 1/12/2009si not shown...date format is month/day/year.....i have posted my code below..
Dim rpt As New CrystalReport8() 'The report you created.
Dim cn As SqlConnection
Dim cmd As New SqlCommand()
[Code].....
I am using VB.NET as front end and oracle 9i as db my problem is this i am writing this query to fetch records between two dates from Key_rec table but the problem is this when i enter the report using dtpicker1 and dtpicker2 these two values goes in txtfrom and txtto then i press view report button but it shows blank report but when i enter the date manually from key board it works fine its mean nothing is wrong with the query there is some problem with the dtpicker1 and dtpicker2 here is the query on btnrep[code].....
View 5 RepliesHow to display records between two dates in vb.net using ccrystal reportsi want to display reports between two dates in vb.netim using sql database name is stud and it contains name age date etc...so now i want to display in the reports as per the date ...
View 3 RepliesI was wondering if someone could help me. I have a database and i want to select all records between 2 dates.I use two datetimepickers and would like my datagrid to show only records between dates selected.
[Code]...
I 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 am have an issue with my between sql string. After testing this i have figured out the problem but don't know how to fix this. When i select two dates i want to get the records between(from two date time pickers) the sql string is taking the day as the month so if i: Input 7/10/2011 the sql between string reads it as 10/7/2011
This is my function :
Function ShowTableBetweenSetDates() As DataSet
Dim ds As New DataSet()
Try
[CODE]...
am using sql 2005 and vb 2008.i need to compare dates and select matching records betweem a selected date range.say records between 11/13/2010 and 11/20/2010.e.thing is working ok except when it comes to selecting dates between 11/1/2010 and 11/9/2010.this is happening because when am retrieving the dates from database,its being retrieved in the format 11/01/2010 instead of 11/1/2010 and so it reports no records found,and knowing the limits of sql 2005 this is the only way i can retrieve the date. [code]
View 7 RepliesI have two dates. [code] How to print all dates between these two dates in one listbox, for example: [code]
View 8 RepliesI am using following code to search my computer for files with certian extensions. I currenty searching for .eml files. This code lists all files found.I need to enter 10 most current files' path to my list box.[code]...
View 1 RepliesI ran into a problem on a program that is ALMOST done!
I have a populated listview of say 100 image directories. of those 100 images, there are groups of 20-30 images. this number isn't always the same, but would be between 20-30 per group. the time stamp would be within 5 minutes on each grouping. how would I go about pulling the most recent only of the 100 or so images? the most recent within about 5 minutes on the time stamp.
I am good in excel and access coding but preety new in VB.net, I wish to prepare an application which will pull details of all the recent users logged in under a particualr domain along with the computer name. I this possible?I did a lot of google and got ActiveDs.IADsContainer and ActiveDs.IADsUser.
View 1 RepliesI am using this to loop through a directory and grab the last modified date for all of the files. How I do find the last or most recent modified date?
Sub Page_Load(ByVal sender As Object, ByVal er As EventArgs)
Dim info As DirectoryInfo = New DirectoryInfo("C:InetpubwwwrootG269_FocusUploads")
Dim files As FileInfo()
files = info.GetFiles("*.pdf")
[code]....
I have what I think should be a simple solution. All I want to do is see what the name of the most recently modified folder was in my c: path.
View 1 Repliesi am trying to create a recent files list. [Code] I've looked and i don't want to use a MRU list as i want it so that it can be used on several devices, i.e. running off a memory stick.
View 11 Repliesi have a form1 and a button1 i want to when i press the button1 ,the recent backgroundimage 'ex.png' changes to be 'ex1.png' what is the code ?
View 1 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.
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
[Code]...
I want to build a recent files list into my program.
The hiearchy I currently have is "MenuStrip>File>Recent Files>File1".
I have a function which saves the files and opens them. It also stores the file name and file path in sperate variables:
CODE:
I would be able to change the text property of the File1 (File1ToolStripItem) to the SaveFileName easily, but how would I make it so that when you click the File1 (File1ToolStripItem) it opens the Savefile file?
I would also need the program to save this list so when I open the program again they are still there.
Is there any way to have a datagridview on a datarepeater with more than 1 row showing?
I have a datagridview on a datarepeater control. The datarepeater and the datagridview are joined on a common field in 1-to-many fashion. The form is designed so that there are 2 rows of the datarepeater visible at any one time. The datagridview is populated in the datarepeater's drawitem event The problem is that it behaves as if there is only one datagridview total rather than one datagridview per row. The drawitem event executes when you scroll to a row. Because 2 rows of the datarepeater are visible, the fill code is executed twice when the form is opened. But the second fill overrides the first one. So you've got this form with 2 different rows but the data in both datagridviews is the same but is right only for the bottom one.
Is there any way to correct this? If I made only 1 row visible, that would eliminate the wrong data. But I want to be able to show more that 1 row at a time.
I have a storedProcedure that populates a dataset, this dataset is then used for a dataSource for a third party grid control. This all works fine, however I am having real trouble in updating the dataSet with the most recent data from my database.Below is the code that I am using to populate the dataSet:
[code]...
I am not sure how to update the dataSet with new data so that my grid control displays the most recent data. Could someone show me the code to do this?
I'm trying to load the most recent file from a directory, but my following code doesn't work. Am i getting something obvious terribly wrong?!
Dim myFile = Directory.GetFiles("C:UsersJoeDesktopXML Logs").OrderByDescending(Function(f) f.LastWriteTime).First()
I get two error messages:
Data type(s) of the type parameter(s) in extension method 'Public Function OrderByDescending(Of TKey)(keySelector As System.Func(Of String, TKey)) As System.Linq.IOrderedEnumerable(Of String)' defined in 'System.Linq.Enumerable' cannot be inferred from these arguments. Specifying the data type(s) explicitly might correct this error.
And:
'LastWriteTime' is not a member of 'String'.
How to add a file history to my Main Menu. I open my windows application and select a txt file to open called "File 1". Later I open "File 2" and "File 3". I have now closed the windows application. A day later I open my windows application again. How do I view the recent files selected to my FILE menu? For example, I would expect to see "File 1", "File 2", and "File 3" under recent files. This would allow the user to easily reference the past recent files that were opened. Word and Excel have the feature and I am sure it can be done in VS2005.
View 5 RepliesI'm using the following code to work out the next unique Order Number in an access database. ServerDB is a "System.Data.OleDb.OleDbConnection"
Dim command As New OleDb.OleDbCommand("", serverDB)
command.CommandText = "SELECT max (ORDERNO) FROM WORKORDR"
iOrder = command.ExecuteScalar()
NewOrderNo = (iOrder + 1)
If I subsequently create a WORKORDR (using a different DB connection), the code will not pick up the new "next order number."e.g.
iFoo = NewOrderNo
CreateNewWorkOrderWithNumber(iFoo)
iFoo2 = NewOrderNo
will return the same value to both iFoo and iFoo2. If I Close and then reopen serverDB, as part of the "NewOrderNo" function, then it works. iFoo and iFoo2 will be correct. Is there any way to force a "System.Data.OleDb.OleDbConnection" to refresh the database in this situation without closing and reopening the connection. e.g. Is there anything equivalent to serverdb.refresh or serverdb.FlushCache
How I create the order.I wondered if this could be caused by not updating my transactions after creating the order. I'm using an XSD for the order creation, and the code I use to create the record is ...
Sub CreateNewWorkOrderWithNumber(ByVal iNewOrder As Integer)
Dim OrderDS As New CNC
Dim OrderAdapter As New CNCTableAdapters.WORKORDRTableAdapter
[code]....
I am working on a new project using VB 2005. Within the project I am calling the OpenFileDialog() command as follows.
OpenFileDialog1.Title = "Select a PDF file to Import"OpenFileDialog1.Multiselect = FalseOpenFileDialog1.InitialDirectory = "C:"OpenFileDialog1.Filter = "Adobe Acrobat(*.pdf)|*.pdf"OpenFileDialog1.FileName = ""OpenFileDialog1.ShowDialog()
[code].....
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?
View 22 RepliesThe Projects List on my Start Page is not being populated with the Projects I open. It's empty.Does anyone know what could be the problem? I can see the entries being recorded in the Registry key:
HKEY_CURRENT_USERSoftwareMicrosoftVisualStudio8.0ProjectMRUList
But VS isn't reading them in for some reason.
I'm running Visual Studio 2005 Professional.