I Currently have events set in my datepicker based of my filter.js file that uses something like:
[code..]
I have these dates stored in a mysql db and I need to pull the dates from it instead of a static js file. Dates can be added, changed, etc.I'm using vb .net
I have a table with dates in mysql that I want to populate a vb calendar with as events, or "active" days.Using a sql statement with something like
Select event, date FROM dateTable WHERE event = eventType.SelectedValue
how do I put these as events on my calender
<asp:Calendar runat="server" id="calendar1"></asp:calendar>
I'm sure I use data:repeater in some way I just can't figure it out.
i have a textbox1 in my asp.net webform which shows the server side date i want the user would not select date using jquery datepicker earlier than the date in the textbox1 i m using the following code to show jquery calendar in other textbox2 :
[Code]...
I am using VB.net as well as Jquery Datepicker for getting dates.
In my VB.net code
<tr><td>
DateOfReceiving:
</td><td colspan="3">
<asp:TextBox ID="DateOfReceivingTextBox" runat="server"
CssClass="pastdatepicker"
Text="DateOfReceiving" />
</td></tr>
I want to allow enter user only todays date or past date with format dd/mm/yyyy. I want vb.net custom validation for that. How to write vb.net regular expression.
I have a local MySQL server which has a database. Now, I want to populate a listview with all entries (Rows) in that database. [code]...
View 4 RepliesI have looked a long time and only found code with c# ans MSSQL, but i want to do this with VB and MYSQL.I populate my treeview with parentnodes with this code. But how do i get the child nodes to the treeview from my childtable?I have parentnodes in one table and childnodes in another.. Or is it better to have em all in one table? I want to have as many childnode levels as possible.My 2 db tables looks like this now:
Table parent looks like this: pID as integer (pk), parentName as varchar
Table child looks like this: cID as integer (pk), parentID as integer, childName as varchar
This is my code now, fetching the parentnodes..
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Page.IsPostBack = False Then
Dim oConn As MySqlConnection = DBConn.getConn("dbname")
oConn.Open()
[code]....
I am a developing an application based on VB 2008 express and a MYSQL database.I have created a database called octupus_db and inside it there is a table called customers.I now have a combo box on my form and i want it to populate its contents from field called town inside the customers table. How do do this? [code]but now connection a table and a field with my application is the next night mare, tried .
View 2 RepliesI have searched and searched but have not found code that worked for me. I need to get the data from a mysql db to my listview. I can already connect to the db, i just need the code to get the stuff from it to the listview.
View 5 Repliesi'm trying to populate a simple combobox with a query to a MySql database. I Just want the combobox to show the results of the query:
SELET DISTINCT models from Cars
I am using VB 2008 with Datasets, how can I achieve this?
using the calendar from the webfor tools, NOT CALENDAR EXTENDER, and my question is, is there a way to add text to a specific day of the calendar, for example, that i want to click on the number where its shows 29 of the month december, then it shows me a texbox or anything that takes data from my, and i type anything in there, like an event or something, then i click on a button to save my entry, and next time i visit my page i see that day that i clicked on changed its color and shows my text when i hoover the mouse on top of it,
View 7 Repliesthis is my class:
Public Class Employeeclass
Public Property Fname As String
Public Property Lname As String
Public Property Bdate As Date
End Class
[Code]...
I'm developing a finance software and I want the user to enter a bill and pick the due date via month calendar. I getting it to work was the easy part, but now I only want one month calendar, for each time a user enters in a bill and picks a date.every time the user goes to pick a due date I have to call one of the several I have on screen.Here is my code that I have so far:Add due date button:
Me
The month calender:
Me
.TxtDueDate3.Text = MonthCalendar3.SelectionRange.Start.Date.ToShortDateString()Me.TxtDueDate3.Text
= MonthCalendar3.SelectionRange.End.Date.ToShortDateString()[code].....
I try to get how many days there are between two datetimepickers, but get convert error no mater what i do.
View 2 Repliescan I tell a standard Datepicker somehow, that Iif I use the Tab Key, it should jump to the next item?
View 7 RepliesI would like to add to my RadioButtonList a ListItem displaying a DatePicker on select. How do I go about adding this in code please, I mean the DatePicker? The code below is my attempt at this but does not work
Dim datepick As New DatePicker
With datepick
.ID = "RadDatePicker1"
.MinDate = New DateTime(CLng("2006-01-01"))
.SharedCalendarID = "sharedCalendar"
.Width = New Unit(100)
End With
RBtnList.Items.Add(New ListItem(datepick, "Other"))
I'm using MaxDate and MinDate to restrict the days allowed to be entered by the date picker, but the dates outside that range of dates are not grayed out, I would like to be able to gray out dates that are not valid, to clearly indicate which dates are valid. Is this possible?
View 13 Repliesi have problem when display date data from database to display on DatePicker.the error is: "Conversion from string "30/08/2011" to type 'Date' is not valid."
this vb
vb.net
dtPO.Value = CDate(dtt.Rows(0).Item("po_date"))
data in database is "30/08/2011", not error if data "07/04/2011"
I am using the vs2008 ReportViewer control, and I'd like to filter the date range on the report by selected it from (2) DatePicker controls. There are a couple of ways to do it I'm sure, but I would like to write the filter as an expression in the reportviewer designer. How can I target a control(s) on my form to filter the expression through?
View 2 RepliesI need to define weeks for my app. So I want to select a certain week of a month. then I want to tick the days that apply and save those dates to a table.
View 2 RepliesI am using a datetimepicker control to record leave dates. Since i am developing the application for a Ghanaian organization, i found out there is the need for me to format the datetimepicker value to suite the users so that it will look like how Ghanaian usaully write their dates. So i have been able to format it perfectly by using this code
[Code]...
I have following code on .NET 2.x:
Dim pDate as Date
Dim dteDay, dteMonth, dteYear As Integer
dteDay = Day(pDate)
dteMonth = Month(pDate)
dteYear = Year(pDate)
I use DatePicker to assgin date to pDate.
If I assigned vaule as 8/2/2010, with above code, dteDay = 8, dteMonth = 2
If I assigned vaule as 8/25/2010, with above code, dteDay = 25, dteMonth = 8
I'm using a datepicker for a field on my form, but the arrows are not visible. If I go to the location where they supposed to be, I can click them to change the month, but the arrows themselves are not visible.
View 1 RepliesI have a datepicker where I would like to highlight (in some way) the dates where I have activities stored in a database. I know how to loop through the database, but I canīt figure out how to highlight the dates in the datepicker.
View 2 RepliesI have a VB 2008 application with multiple DataPicker fields. The data is binded to SQL database. On the form load I set the checkBox for each date to false if there is no date in the field. Noticed that if I make changes to some dates for record 1 in the table, save it and scroll to the next record - I see the date that I just changed for record 1 - also on records 2 and 3. Why is it happening? I don't have that problem if I use text fields to display the dates. I had encountered the same problem with different project and just switched to text boxes. With this new project?
View 15 RepliesI have a datatemplate for my listbox:
<DataTemplate x:Key="CheckBoxTextBoxItemTemplate">
<StackPanel Orientation="Horizontal">
<CheckBox Focusable="False" IsChecked="{Binding IsChecked}" VerticalAlignment="Center"/>
<ContentPresenter Content="{Binding Name, Mode=OneTime}" Margin="2,0" Width="140" VerticalAlignment="Center"/>
[Code]...
However the items in the list that the listbox is bound to are not all String types. Some are DateTime and a few are Integers. I would like to have a datetimepicker displayed instead of a textbox for the DateTime types. How can I make this happen.To clarify some points the list is populated at runtime using reflection so I don't know which fields are what types ahead of time.
I add a date picker as follows
Friend WithEvents dtpReportDate As System.Windows.Forms.DateTimePicker
The default date picker has left arrow and right arrow which allow you to browser previous month and following month. I add a handler to date picker valuechanged event:
AddHandler dtpReportDate.ValueChanged, AddressOf dtpReportDateChanged
Private Sub dtpReportDateChanged(ByVal sender As Object, ByVal e As System.EventArgs)
'do something here
End Sub
The problem is that whenever I click left arrow or right arrow to change month, the dptReportDateChanged is triggered. I do not want this happens. All I want is that after I find a month, I double click date to trigger the event.
I have noticed that hwen i set the datetime programmatically on the wpf datepicker the writing "show calendar" does not disappear but remains visible underneath the date passed?is there a way to solve this problem
View 3 RepliesI have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
