Im having problems in saving the date selected. When I clicked my save button, it is saving the current date not the date i choose. The date I selected is for the Birthday.Here is my code for saving:
Dim myBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(dataAdapter)
If dt.Rows.Count <> 0 Then
[code].....
I try to make a WFA for filling, reading etc. to a database. I want to compare 2 dates (actually 1 date is changed by 42 days) that are chosen by a user through a datetimepicker. After comparing the 2 dates the "newest" date has to show up in a non editable textbox. This Is my code (of course I have 2 subs for the datetimepickers as well).
Private Sub AwbdatumTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AwbdatumTextBox.TextChanged
Dim DatumbinnenkomstDateTimePicker As DateTime
[code]....
i got the "downloder with progress bar" from some one on this site. but i want it go begin downloading when i have chosen my desired path. but i just dont know why
View 9 RepliesVS 2008 Starting a program with a chosen path
View 6 RepliesHere is my current file
Public
Class Form1
Dim ScreenData(3, 4) As TextBox
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
FileOpen(1, CurDir() &
[Code]...
The following code throws an error on saving a record: "Conversion from string "TDT" to type 'Integer' is not valid" The following code is highlighted:
da.InsertCommand.Parameters.Add("@TDT", OleDbType.Date, "TDT")
"TDT" is a MS Access field name for storing date.
I have an issue with date format in my SSRS. I am saving date from DateTimePicker to database. From there I am taking display in my datagridview using following
dgv.items(0,2).value=Format(Cdate(dsSaver.tblInv.rows(0).items(0)),"dd-MMM-yyyy")
This displays it correctly (04-Nov-2011) but when I take date from the same database to my SSRS using
="Dated: " &Format(cdate(Fields!InvDate.Value),"dd-MMM-yyyy")
It displays it like 11-Apr-2011.
I have tested all winforms fare displaying it right but all SSRS are displaying it wrong.
I have the following Public Class Payroll Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
[Code]...
and I'm trying to save the datetimepicker value as a variable to pass to a sql database. I'm just not sure what the datetimepicker value is, is it Me.DateTimePicker1.Value or is it dt?
I'm using a MaskedTextBox, named txtDOB, into which the user types a date (the mask property is "00/00/0000"). This value is then stored in an array
Dim NewStudentFields(37) As Object
NewStudentFields(4) = txtDOB.Text
And the array is passed to a subroutine which uses the data to put into a new table row.
Some of the code from this sub:
da.InsertCommand = New OleDbCommand("INSERT INTO tblStudentInfo (FullName, FirstName, LastName, Gender, DateOfBirth, etc.etc.) VALUES (@FullName, @FirstName, @LastName, @Gender, @DateOfBirth)")
da.InsertCommand.Parameters.Add("@DateOfBirth", OleDbType.DBDate, "DateOfBirth")
If NewStudentFields(4) <> " / /" Then
dsNewRow.Item("DateOfBirth") = DateTime.Parse(NewStudentFields(4))
Else
IsDBNull(dsNewRow.Item("DateOfBirth") = True)
End If
The code executes as far as the red line which triggers the error message "Conversion from string "DateOfBirth" to type 'Integer' is not valid." There's probably something wrong with the final "If...End if", too!
I am coding ib Visual Basic. I need to store the current system time in MS Access timestamp field. How do I go about it.
Dim row As DataRow = ds.Tables("StudentTable").NewRow
row("SSMA_TimeStamp") = System.DateTime.Now.ToString()
Right now the existing VB code I have uses GUID to generate "random" filenames on save.
For instance:
ff8514d389a041649fd8b925a32f2b51.jpg
e1c938560fc1464ab2138065fc4661d3.jpg
Instead I want a date stamp, Time Stamp, and numbered filename:
For instance:
20091015_131644_001.jpg <--(Date_Time_NumberIncrement)
20091015_131551_002.jpg
Or something along those lines. The current code (which saves a jpeg to a random GUID filename) is below:
Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.IO
[Code] .....
Right now the existing VB code I have uses GUID to generate "random" filenames on save.
[code]...
Instead I want a date stamp and numbered filename:
[code]...
rewriting a class I use for saving Treeview data to a XML file for use of saving ListView data I can't really figure out the rewrite, I'm stucked, unfortunately Listviews seems to be a big problem for me in general.
Option Strict On
''' <summary>
''' The TreeViewDataAccess class allows the nodes within a TreeView to be
''' persisted to xml for later retrevial.
''' </summary>
[Code]....
How can I determine which box a user has chosen from the points array I stored it in? EX:
Points.add(box1)
Points.add(box2)
Points.add(box3)
User selects box2
How can I determine from the points array(x) which box he chose?
Im not good in querying. I would like to ask if this query works.I want to retrieve starttime, endtime and sessioncost from the table SESSION of my database. my program will be an autorun.
Dim sql As String = "select STARTTIME, ENDTIME, SESSIONCOST from SESSIONS where CLIENTID = (?)"
I have four comboxes all containing A,B,C,D. My problem is if I have chosen letter A on the first combobox, the last three won't have letter A anymore, then on the second combobox, if letter B is chosen, the last two will have C and D and so on.
View 8 RepliesI would like to create a program which able to lock several files from unauthorized person to use and unlock it when the authorized person wants to use
View 12 RepliesI'm trying to make an autoshutdown, that can, of course, shutdown your computer but also open a program when you want (I'm working with vb 2008 btw), I was thinking in using openfiledialog, get the path to a text box and then open the file with shell.
View 2 RepliesSo I'm making a multi-function clock for practice.
It's a clock, timer and alarm. It's all done except for the alarm. I want to be able to choose a song (mp3) with OpenFileDialog1 and then play it when I click a button. I'm thinking about using a hidden Windows Media Player control,
lock/delete this thread if you wish.
View 2 RepliesI've searched for a solution with no luck, can you help? I've a DataViewGrid with a DataGridViewComboBoxColumn, bound to a dataTable which all works fine but I need to undo the user selection in some cases.
When the user selects one of options I validate that the chosen option is appropriate for the rest of the row. I can do this in the CellValueChanged Event and easily determine if its good or bad - is this the correct event to do the check?
The problem I have is that I want to roll back to the default value in the DataGridViewComboBoxColumn if an invalid selection is made:
[Code]...
Can a media player written in VB be modified to do this: randomly choose an avi file from a directory or subdirectory, choose a random starting point within that file and then play a clip of a random length (within user defined parameters) then without prompting repeat this sequence?
I would like just such a media player but there doesn't appear to be one already out there so my only other option is to write one myself. I know nothing about VB and last programmed in BASIC in the 90s. Before I invest time and effort in learning VB I need to know if it can actualy do this at all.
i need code for chose any txt file and opening it from open file dialog (if thr user click in open button)and display the content of chosen txt file in textbox
View 2 RepliesHow To Find Screen Pixel Of Choosen Color?
View 13 Repliesi ve got two radiobuttons one labelled male and the other labelled female and a client is supposed to choose which gender they are and insert it into the other database along with other information. I want to know how I can insert the chosen value (male or female) into the database
View 2 RepliesI need to make a report but my columns will be chosen in run-time. I used to make report with crystal report by filling my data to query table and connect this query table with designed report by crystal report. but this time the user will choose the fields in run-time.
View 3 RepliesI have created the random bingo calls needed with the standard bingo letter restrictions.. i.e. B = 1 - 15, I = 16 - 30, etc. I have a form with 5 columns with B I N G O at the top and the corresponding numbers beneath. Those are labels named lblB1, lblB2, etc.
My problem is that I can't seem to figure out how to get get the text to change on the called tiles. Logically it would be easiest to use something like
varLabel="lbl" + varCalled
varCalled.Forecolor = red
Where varCalled is the ball number being called.But.. that is not the case. (I'm at work so can't submit the actual code at this time.. will do so later if needed)I've done some searching and can't find anything that helps out.. but searching for "change label color dynamically" comes up with how to change the color of a label at runtime.. not sure how else to search on it.
I am using combobox to populate values from a table, 'Suppliers'. I put this combobox in a form wherein the order details are filled up. This column 'Supplier' is a Foreign Key and set to NotNull in the order detail table. Selecting the first available entry on the combobox gives error 'SupplierID cant be Null' . Selecting the 2nd value is OK, first choosing 2nd and coming back to 1 is also OK. This error comes up when trying to update the database.Even with the first value, the combobox is having a text. I would like to know why the error.
View 5 RepliesI use VB 2008, and have "moderate" programming skills.I've constructed an xml file:[code]
View 4 RepliesI am working on a GUI for a simulation program. The simulation program is a single .exe which is driven by an input file (File.inp placed in the same directory). The Original.inp file functions as a template from which the form reads all the values into an array. Then it changes these values reflecting the changes done by the user in the form. After that it writes all the new values to File.inp. By pushing the "Run" button the Simulation.exe file is executed. The folder structure looks like this:
[Code]..
Ideally I would supply only the GUI, the user would select the working directory and then the GUI.exe would create an input folder and extract the Original.inp and Simulation.exe in the appropriate locations. So far I have only managed to include Original.inp and Simulation.exe as "EmbeddedResources" in my VB project and I have let my code create an input folder in the working directory chosen by the user.
how I can extract the .inp and .exe file into the correct directories? I've searched on google, tried File.WriteAllBytes and Filestream.WriteByte but did not get the desired results. The problem with File.WriteAllBytes was that I could not point to the embedded resource ("Simulation.exe is not a member of Resources" and with Filestream.WriteByte I got a 0 kb file.