Now using VS 2008
Before I used VB 6, now I Upgraded to VB 2008.
VB6 Code
sdate = DateToString(dtpicker1 - 1)
edate = DateToString(dtpicker2)
Above code is working fine.
After Upgraded to VB 2008
sdate = DateToString(dtpicker1._Value)
edate = DateToString(dtpicker2._Value)
If I Put
sdate = DateToString(dtpicker1._Value - 1)
It is showing Error.
How can I write a code like dtpicker1 - 1
i'm having a problem how to code to save the value of my dtpicker as string not in date/time value. i formatted my dtpicker as mm/dd/yyyy. i want it to save in my database as string format. my datafield in my database is in text format not date/time. is it possible to save the value of dtpicker as string format?
View 9 RepliesI am using dtpicker1 to select the date here is my code
[Code]...
Now the problem is this when i select the date from dtpicker1 it inserts the date in textbox in this format "07/12/11" but i need this format "07/12/2011"
how I can ensure that conversion of a date to a string and a string to a date will give me the same date format.
For example:
Code:
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim d As Date = Date.Now
[code].....
I'm actually only interested in the date part as the label text shows so f is more than I want.But also, the day and month are reversed.
I am developing one desktop application using vb.net 2008 and Microsoft SQL Server 2005. fetching the data from database between a given range.
the date field in my table is of type VARCHAR(25) and the date format stored is dd-mm-yyyy. when I using the between clause in the SQL query then it is not giving all the data every time i.e. the date criteria in where clause is not working fine.
while my clients requirement is to keep the date format as dd-mm-yyyy and fetch the data according to the given range.
I search on the forum and found many queries to fetch the data by converting or type casting the date field within sql query but nothing worked.
The table structure that I am using is as follows
USE [Firm_master]
GO
/****** Object: Table [dbo].[tblTransaction] Script Date: 05/17/2011 21:49:11 ******/
[Code]....
I have inserted a dtpicker in my data grid when i run my form i am able to select date from dtpicker but when i select the date using dtpicker it didn't save in db here is my code on save button [Code]
View 3 RepliesDoes anyone here knows how to use the DTPicker and to bind data from it using ADO Connection? I need to know how to use it for my training. I looked up in the net but found only inappropriate answers.
View 1 RepliesHow to store time from DTPicker in SQLServer 2000 when the front end is in VB2005. I am using the following. In the add form:-
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim dsNewCustomer As DataSet = DataAccess.AuthorData.DataModule.GetNewAuthor
Dim frm As New frmAuthor
frm.MainForm = Me
frm.LoadData(dsNewCustomer)
[Code] .....
Time is not getting stored in SQLServer2000 database.
Title pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 RepliesHow can I make my program operate in a sandbox for security? I am using Visual Basic 2008 Express.
View 6 Repliesi am new to this forum, hope u people will help me out.i need to add header to a text file which is created using my code.
View 4 RepliesI have a question. I'm using visual studio 2010 and I am making a windows application and I set the framework for the app to .net 3.5..I have some threads in my app and when I run it on my output screen it says: ' The thread '<no name>' (0x***) has exited with code 0 (0x0).Does anyone know how to change the '<no name>' ? MatthiWare N°1 .NET Freeware & Shareware site! Title: Project leader, Owner @ MatthiWare Current project: MW Virtual Desktop Contact: Admin@matthiware.net.ms Website: MatthiWare " MatthiWare... What else?!? "
View 2 RepliesI have a datagridview which fetches data from a local SQL server. Now, I have a setting called My.Settings.database_url which indicates the hostname of the SQL server.
Now, the problem is that if the host name is incorrect, instead of getting an error, the app just freezes. So what must I change in order to fix that?[code]...
Sometimes the app is working in a long time process, and I wnat to tell the user something like "Wait a moment, please"
I though to use a modal form but if I show this form, the process I said is not initiated.
How can I give this kind of messages?
Is there a way to give a value to multiple variables (integers in this case), instead of all at once?
For instance, I have Dim aceVal, twoVal, threeVal, fourVal, fiveVal, sixVal, sevenVal, eightVal, nineVal, tenVal As Integer and, pending listbox selection, I'd like to assign threeVal fourVal and sixVal all values of -1.
I need to create a variable which can symbols for only "1, 2, 3, 4, 5, 6, 7, 8 or 9 " so that I can use to check for a certain text.[code]...
View 9 RepliesI have a 2 combox's with the following items, Excellent,Good,Average,Fair,Poor in them and a textbox with a user defined numeric value
I would like to be able to do the following:
perform a calculation based on values in each box , example
combox1 = Excellent
combox2 = Good
textbox = 1000
[Code].....
I'm trying to figure out how to give Messagebox a timer. I found that people said i need to make a new form with a timer, How do i go about doing that?
Public Class IntegerMath
Private Sub BtnIntMath_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnIntMath.Click
[Code].....
I have used the
<ScrollViewer CanContentScroll="True">
<TreeView ...>
</TreeView>
</ScrollViewer>
but not properly working I want a new one
I have a grid view in my application i want to give underline to each row i dont want entire border to be shown?
View 4 Replies:idea:I'm a bit stuck I wrote a printing part.But cant find how to preform a pagefeed
rivate Sub PrintBTN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PrintBTN.Click
copieen = 1
[code]......
I have a DataGridView to display the content of my database. I Queried the required fields to a Dataset and Used this as DataSource for the Datagridview. Now i want to add dropdown filters to each column as we see in Excel Sheets. Is it possible and how.
Any how i require dropdown for the columns i also tried from below link to set the BindingSource.Filter = value but i did not find this property for Datagridview[URL]..
how do you give focus to a file open with process.start?
View 7 RepliesDim Sql = "UPDATE employee SET [password]='" + TextBox2.Text + "', [Question]= '" + ComboBox1.Text + "', [Qans]= '" + TextBox4.Text + "', [employeeName]= '" + TextBox6.Text + "', [employee_MI]= '" + TextBox7.Text + "', [employeeLname]= '" + TextBox5.Text + "', [Birthdate]= '" + DateTimePicker1.Text + "', [Occupation]= '" + TextBox11.Text + "', [Address]= '" + TextBox12.Text + "', [Gender]= '" + ComboBox2.Text + "', [CivilStatus]= '" + ComboBox3.Text + "', [Citizenship]= '" + TextBox8.Text + "', [Telephone]= '" + TextBox9.Text + "' WHERE username = " + TextBox1.Text + ""
[code].....
This is a part of my code of a VB GUI
[Code]...
how do write the value of the integer TotalPrice to lblPrice ?
I need to set my application to save entry (e.g LoggedOff) to database if application shuts down abnormally, like power failure or anything else like that.
What event should be fired to achieve this?
I am a beginner who used to use VB5 seven years ago, but am now trying to get up to speed using Visual Basic .NET 2010 Express in XP.
A difference I have noted is that in VB5 my buttons appeared to be three dimensional (raised) due to shading, etc. With VB2010 my buttons are plain 2D. I have not been able to find a property to give them the 3D appearance.Is this a limitation of using VB Essentials? If not, what properties give buttons the appearance of 3D?
I have following query,
[Code]....
how to do it in linq queries ??? also is it possible to combine firstName and lastname in select query in Linq ? just like we do in SQL Queries like : select me_first_name + ' ' + me_last_name as 'Full Name' from me_employee how can i achieve this task in linq?
I've heard this is possible, and my code to mimic this possibility is not throwing an error but it's also not a part of the intellisense architecture.
[code]...
So i need to give backspace function to my menu here is the menu:
[Code]...
