Hi,
Within ur SQL statement u format the selected field.
For example : SELECT format( PaymentDate,'dd/MM/yyyy') FROM Payment.
Carol,...
User Profile
Collapse
-
VB.Net DateTime Problem
Hi,
I try to bind records into datagrid based on certain condition.The condition is when the Rdate in database column is larger than today date will be display on datagrid.
my problem is , the records display is not fullil the condition i set. as long as the day value(dd) (RDate) is larger than today day value(dd), it will display on datagrid.It ingore the Month and Year.It seen look like it compare as string instead of dateTime.... -
Counting number of records
Hello…
I have problem when counting the number of records, which is based on the start date and end date.
I have tried to use message box to prompt the result, but the result given is zero(0).Actuall y there have records in database which fulfill the “WHERE” clause condition in sql statement.
Thanks for yours help…
Carol,
/* Below is my code sample(VB.NET) */
sDate = dtStart.Value.T oShortDateStrin g... -
Problem with Embedded Resources (Sound File)
Hi...
I have a problem when i try to insert a sound file (.wav) to my project but system prompt me an error message as follow:
“An unhandled exception of type 'System.NullRef erenceException ' occurred in Application.exe
Additional information: Object reference not set to an instance of an object”
When I debug, it prompt an error at the if statement, when mouse move
over to Str, it's nothing.
... -
Raising an alert
Hi...
I just want to know how to raising an alert.
For example, when i login to the system, the system will raise alert if the product's expired date is today date.
Programming language=VB.NET
Platform=Window XP Pro,SP1
Software=MS Visual Studio.net2003
Thanks....
Carol -
Export Data to Ms Excel 2000
Hi ,
I have no idea on how to export data to Ms Excel 2000.
I have a screen which contain a check box list that allow user to select which fields to be exported to MS Excel.
When user checked on the check box, that field's data from database will be exported to Ms Excel.
My program is client -based system.
Programming language=VB.NET
Software=MS Visual Studio.net2003
Platform=Window XP Pro,SP1... -
Expand TreeView nodes
Hi,
How can i expand all the treeview nodes when i have just simply click on ExpandAll button. This program is write using VB.net.
Thanks for ur help.
CLL -
Package VB.Net application
Hi,
I dont have an idea on how to package VB.net application and make it as .exe file. This application is a simple program which use to keep track Employee's Personal Details.
The program is run on Ms Windows XP Pro,Service Pack1.
Programming Languege using = VB.net
Application software = Ms Visual Studio.net 2003
Thanks...
Carol
No activity results to display
Show More
Leave a comment: