I've hardcoded my date into my app, but now I want to read it from the database. I knowhow to read the columns, but unfortunately I don't now how to make the date appear into the monthcalendar.[code]...
View 16 RepliesI am trying to get the date parts selected by a user on the MonthCalendar control. I know how to set the date, thanks to some help from this forum. Now I have run into another problem. I need to be able to take the MONTH, YEAR and DAY selected by the user. I have tried this example I saw, but it does not work, mmDay = CalendarMonth.Tex.ToString("d").
View 1 Repliesi am having problems getting my calendar to work, passing a start and end date for a rental car and displaying on the form the number of days chosen and the amount for the total. This is the first form problem I have done. I cannot see what I am doing wrong. It does not figure number of days and the amount just stays zero.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
[code].....
I would like to be able to either: (1) Pick a date from the Monthcalendar box and have it insert that day into a textbox showing in a format of Day of week, Month/Day/Year or Day of week, mm dd yyyy. or in option #2 be able to enter in the date by mmddyyyy and get Day of week, mm dd yyyy showing in the textbox.
View 1 RepliesI have a question: How do you set the color of a date in a MonthCalendar? I used this code, but i get errors
ViewStayingPattern.MonthCalendar1.ForeColor.Red(NewDate)
*NewDate is the date I want to be colored.
How does one set the date in MonthCalendar control. I am using VB2005.NET. I am new to this - from VB6.
View 1 RepliesI am using MonthCalender control in vb.net to select a date. I am able to save the selected date to DB and also retrieve and bold the previous selected date. But even though date is bolded it is not displayed when the form loads. It still highlights today's date. What Do i do to highlight the previous chosen dates. Also i want to disable choosing date range.
[Code]...
I created a monthcalendar usercontrol and calling it from a parent form (in this case, click on button to populate the textbox beside it). Two questions.
1. How do I return the selected date back to the parent textbox?
2. How do I bring the monthcalendar usercontrol to the front and back of other objects?
Can I change a bolded date's color of a MonthCalendar control without creating a new custom control? Should I override OnPaint event, or something for this? If so, how?
View 5 RepliesI've seemed to found some interesting behavior with the stock MonthCalendar control. I've set the MinDate property to 1/1/1990 but when I try to actually select a date anywhere previous to 1/1/2000 it jumps to 12/31/2999 why is that?
I've tries manually setting it to 4/8/1998 and it jumps to 4/8/2998 which isn't what I would expect a calendar control to do. Is there a reason it keeps it within the 21st century?
I want to enter Year, Month & Date in a separate TextBoxes to get a Function work as these 3 have to be given as parameters for that Function. I've been using 3 different TextBoxes to enter the Year, Month & Date. Now, I thought of using either a DateTimePicker / MonthCalendar for this. how to get it done. By clicking a Date in the DateTimePicker how can I get the Year, Month & Date separately fed into the Function? [Code]
Is there any way of getting the year, month & date separate from the DateTimePicker / MonthCalendar?
I have a month calendar on a form. It is showing 2 months, when I select the start date for a range of dates, the month calendar blinks for about 1 second. Here is the code that gets the start date, sets the end date (28 days later), then assigns a date to the text of 28 checkboxes by looping through the control collection.[code]
View 4 RepliesWhen I select a beginning date on my MonthCalendar control it blinks real quick and then reloads,I am pretty sure this is not a normal behavior?code to select bolded dates and set beginning date and set controls with date range:
Me.txtStartDate.Text = Me.MonthCalendar1.SelectionStart.ToShortDateString
Me.txtEndDate.Text = CStr(Me.MonthCalendar1.SelectionStart.AddDays(27))
' create an Array of dates to hold the Range of dates from the MOnthCalendar[code].....
I am using ASP.NET with SQL Server 2005.
My date get saved in the database with data type = "smalldatetime".
I am displaying the date value into a text box called txtDate with a Reader......
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[Code]....
But currently my date get displayed as "2008/06/30 12:00:00 AM" and i want to display it as "30 June 2008".
my sql statement is returning null when when I compare date from access database and date entered in textbox in vb. seems to me that the two dates are of different format so null is returned from the select statement but how do I go about this.[code]
View 3 RepliesIn earlier vb.net 2008 I used the DateTime to read the date in dd/mm/yy format. I use to change the culture info to UK format. So that the date will be selected from SQL server as in dd/mm/yy format.
But I know it's not good to play with CultureInfo. Even though I used like the following manner.
Sub Form_Load()
Thread.CurrentThread.CurrentCulture = New CultureInfo("en-GB", False)
End Sub
I am trying to read a date from a cell in excel into a datagrid and then compare the current date to the one in the datagrid, however vb.net converts the date (which should be of the form 03/09/2011 UK style) into a number so for instance 03/09/2011 becomes 40789
how do i keep it as a date so i can compare it to todays date?[code]...
I need to know how i can read REG_BINARY Type as string or date
View 2 RepliesI am reading a CSV file using OLEDB command in VB.Net
Everything is working fine. the only problem is that one of my columns has time value in a format "07:53.8"
When i read this value using dr.item(1), it reads the string into a date "01/25/2012".It gives me the same value in dr.item(0)
I am not able to read the correct value as shown in the CSV file.
following is the code
For I As Integer = 0 To 2
dr = dt.Rows(I)
MsgBox(dr.item(0))
[Code]....
When I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
my date and time picker cant get data on my SQL yog database it only get data on year 2011 .it cant show me data on year 2012...i hava a range of date.my code is :sSQL = "select * from qry_reciept where product_name LIKE '%" & txt_name.Text & "%' and b_desc = '" & cbx_brand.Text & "' and d_purchased >= '" & datetimepicker_1.Text & "' and d_purchased <= '" & datetimepicker_2.Text & "'"
View 5 RepliesI thought I only needed to click or double click a day on this controll to change it. Do I need to create a click event and if so (I have installed MSDN for VS2008) can I see what events are available.
Desmond.
PrivateSub cmdCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCalculate.Click Dim Days AsInteger Dim Today As DateTime = DateTime.Now
[code].....
Can I add a listbox in monthcalendar?
Listbox contain time..
I saw a Digital Diary and want to create one by myself to learn the techniques. I'm learning Visual Basic (2005). I want your help for the followings; 1) I want to get the "page" (the RichTextBox) linked to the dates in the Monthcalendar ie I wrote something for 20th Oct 2009 and saved, then I select 12th Nov 2009, write & save. I want the page for 20th Oct 2009 opened when I click the 20th Oct 2009 in the Monthcalendar Or page of 12th Nov 2009 opened if I click the 12th Nov 2009 in the MonthCalendar. Can you explain how to do this? Please tell the codes.
2) On starting the program, I want the "Page" for the current Date appears. (and on changing the Date, the "Page" for that particular Date should be opened.) 3) I want to make the User to create a UserName and enter a Password (User selected - can be changed at any time by him) to open the Diary. (Similar to the User account with Password in Windows.)
Is it somehow possible to use MonthCalendar as DateTimePicker? Initially current date in Monthcalendar is highlighted, but it is possible with mouseclick to highlight whatewer other date. Does there exist a method or function or something else to retrieve
View 1 RepliesO/S WIndows 7
SQL Server : SQL Express 2008 R2
VB 2010 Express
SQL Server is located on the workstation so the code and the DB are on the same PC
Created a DB connection using the wizard. Tried this with Windows authentication and SQL authentication using sa
Created a Dataset and dragged the grid onto the form1.vb.
In SQL Sertver Management Studio I can update update tables using the same credentials as in the VB connection string
WHen I try to update a record in the VB Dataset it returns the error cannot update database because it is read-only
I have checked the files and folder attributes in SQL Data folder. Nothing is set to read only
I have checked SQL Server Database > Properties > Option > State > Databse Read only = false
I don't what I'm doing wrong here but I cannot get VB to update data via the dataset.
Inotice in SQL Server that the DBname now includes the full path "C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAPAYABLES.MDF" and not just the DB name. Is this becuase VB Express requires you to point to the physical DB file?
I try to make some personal diary with VB.Net and i'm using Monthcalendar for the date. but i have no idea what can I do with monthcalendar is it possible for me to attached some data / text (save using .txt file) and highlight/bold the date ? or how to fill monthcalendar array with specific date without using DateTime collection Editor?
View 14 RepliesI put on the form a tool MonthCalendar and I tried to chang the size ( width-length ) by mouse or from properties but it didn't accepted, it keeps the same size
View 4 RepliesWhen you open a MonthCalendar control at runtime, and click on the top Month designator, it takes you to a list of all 12 months in order to jump back or forward to a desired month quickly.
My question is, can I restrict the user to only viewing this 12-month calendar at start-up, so that I can just read the Month the user wants to say run a report from.
I realize I could use just a DropDown, or list box with the 12 month names in it, but since the control has this ability to view by month, I figured I would ask.
It would also allow me to reuse a control that I also use to pick a specific date, keeping my code a bit more compact on filesize, and save the control space for a new Combobox or something.
I put a monthcalendar in my form and when I select a range of date, the selected area goes white, all the dates in the selected range go white. I have no clue how to fix this.
View 1 Replies