I am trying to get so users can select there dates from a calendar and those selected dates will put into a sql query to pull from a database. I am stuck on how to get strings of the dates to fill the query.
Imports System.Data.SqlClient
Partial Class TEST
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code] .....
I've been making a scheduling program using the calendar object.I can manage to select any date with a single click with a message box pop up entering a memo for the date selected. After pressing ok, the memo is displayed in a list box, with date.
1.Unfortunately the date is being displayed twice - perhaps because i used .selectedrange in the handler ? i would like it to be listed only once
2. the memo comes up on a separate line, ideally id like it to be displayed on the same line as the date.i tried ListBox1.Items.Add(whendate, memo) but it cant compile, so ive had to put each line in seperately
3. I would like to mark the sundays and national holidays in red color (the calendar is only set for a year so i dont mind doing them by hand, however the only tool i can find in the Monthcalendar1 properties is MonthlyBoldedDates, and no color assignment [code]
I am interested in showing list of 12 months like in similar way to datepicker's month selection control. But i don't like to show the date picker to show the dates of that month too... only month view is ok so that i can select month from the list.
View 2 RepliesAssuming that i picked a day from a Calendar component on VS 2008, how may i add a specific number of days to the date? (i've to store the final date in datetime datatype to DB after which) Parsing involved possibly?
View 1 RepliesWhen I clear my form, I am trying to clear the Month Calendar of all selected dates. Using this code clears everything but the Selection Start Date, I would assume there would be a way to clear this, Refresh doesn't work, and I can't seem to find anything else.
Public Sub clearScheduleControls()
Me.MonthCalendar1.RemoveAllBoldedDates()
Me.MonthCalendar1.UpdateBoldedDates()
[Code]....
I am trying to find a way to use a month calendar control as an object data source, such that when end user selects a given date, or a date range (1 week max), it will supply the date range criteria for an access query, and the results will wind up displaying in a data grid view below the month calendar. I am having a really hard time..
how to write the date criteria into the access query for something like this
there are three tables in dbf , table1,2,3 respectively all are contains similar structure but different data Structure : S.no Quiz Question i want the query which select the Quiz Question/records through user given Range from Textbox1.text to Textbox2.text
View 3 RepliesMay i have a working sample on how to retrieve records from a DB & populate the relevant textboxes after a selection at a dropdownlist. What i have is definitely not working & im working on VS 2008. Can anyone show me the way?
[Code]...
your life whatever you are doing.I have a big question. Well, it's a big job for me. I tried to google and follow some tutorials frist but finally realise rom stackoverflowers.I have a one big xml file such below. I have no control over its structure as it already exists with data.
<?xml version="1.0" encoding="utf-8" ?>
<root>
<Category Cat="A">
[code]....
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 RepliesI'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 am trying have a data grid selection populate a form. I am new to this.Basically I have a connection persistance object and I would like to call that and call a stored procedure with the value of the selection. The datagrid is bound to an object.
[Code]...
I have a listbox (20 Items) with multiselection and label that disply the selection and one button. So I wrote (it works fine)
[code]...
Now when I click on button the label show lets say Item2,Item5,Item10,How do I take off the last ","
somthing like that Item2,Item5,Item10
I used to do: Dim s As String = Trim(Label1.Text)Label1.Text = s.Substring(0, s.Length - 1) but it give me an error converting intiger to string
osheet.Range("A1").Select
'The line below is the one I would like to know how should I write it in VB.NET:
osheet.Range(Selection, Selection.end(xlDown)).Select
[code]......
I am using this code to select a folder.how to do the same kind of thing selecting a file instead of an folder.
Private Sub PathButtonB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PathButtonB.Click
Using FolderBrowserDialog As New FolderBrowserDialog
With FolderBrowserDialog
.Description = "Kies die Folder waar hierdie ResepteBoek die Kunswerke vir sy Resepte moet gaan soek."
.ShowNewFolderButton = False
[code]....
Found this:
Sub SurroundWithAppendTag()
DTE.ActiveDocument.Selection.Text = ".Append(""" + DTE.ActiveDocument.Selection.Text + """)"
End Sub
But I can't seem to figure out how to loop through each line of text in the selection.
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
When Creating a query using the sear Criteria Builder . I keep getting the error : "The schema returned by the new query differs from the base query" what does that mean and how do i avoid this problem in future
View 2 RepliesI'm using visual studio 2008 and creating a Windows For Application.
I'm almost completed my little application and what I've discovered just recently is that any change I made is not taking affect.
What I mean is if I change the display name of a button or insert a msgbox popup, it doesnt make it to the build when I run it. There are no errorswarnings.
I have a long string that I need to take apart two values, and add them into another string.
View 3 RepliesThe problem I'm facing is that PrintForm has a shoddy quality while getting the printouts and PrintDocument takes way too long to get on receipt printed (Almost 5-10 Seconds!)I'm either looking for an alternative for PrintDocument or somehow make the PrintDocument run faster
Dim
printFont As
New
[code].....
im trying to get a name entry from an input box to show up in two separate places on my project, ie first and last name, but i either get nothing or the same text for both labels.[code]
View 6 RepliesI am writing an app to take ID pictures using a webcam, I need a PictureBox to display a live image of the person sitting infront of the webcam in which I then need a captured picture to desplay as soon as a Button is clicked.
I don't even know where to start.
1. How do I get the PictureBox to comunicate with the webcam?
2. I also will need to crop and resize the picture and then print it, but this we can diskus later.
I have created an xml file and i would like to now extract data from it.
Is there a function within vb.net that reads xml and takes out all the attributes with a certain name? For example to withdraw all the authors names from an xml file about books?
But like always I have a question. I need to take the data that I have stored in arrays and use it. But how do I do that? What I need is to take numbers stored in the arrays and add and subtract them and put them in the appropriate array , like this:
[Code]...
Is there a way to use ReadAllLines to read in a text file that contains some Chr(10) (linefeeds) but uses ONLY the Chr(13) (carriage return) as the true end-of-line?What I mean is, DON'T treat a Chr(10) as the EOL. ONLY treat a Chr(13) as the EOL.Obviously I could just read in the whole file as binary and then split it into lines by scanning for Chr(13), but I just wondered whether or not there's a setting in VB.NET to set the EOL character so I didn't have to do that.
View 4 Repliesi found some code to take screenshot from screen it works perfectly - changes and my vb.net - skill is pretty low ode is here:
Imports System.Runtime.InteropServices
Module Module1
<DllImport("user32.dll")> _
[code]....
I have this fingerprint scanner I'm working with. The fingerprints taken are index/stored in our imaging system and the fingerprints are put on certain documents and printed.When I scan the image in and then load it into a bitmap object, the width and height are (w:480,h:640).Now if I open this file in any image viewer and print it from there the finger print is as big as a fingerprint should be.Now when working with it in code, it's huge. I have found some resize code online, but the resulting image is horrible.Is there anyway to resize an image while taking in account the dpi and such so the image is highest quality (same as print out?).
View 2 RepliesI made this VB.NET code to take a picture of my entire screen, but instead it only takes a photo of the focused area. Why is this?
Public Function SaveScreen(ByVal theFile As String) As Boolean
Try
SendKeys.Send("{PRTSC}")[code]....
I'm watching tutorials about creating Web Site and about controls.I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.I have TextBox1, TextBox2 and Button1 on the web site form.I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.Who can help me with that? Should I read about ADO.NET and use something from there?Later I want to use VB for work with that strings.
View 2 Replies