i have problem about datetime i use os vista,sql server 2005,vb.net 2008 string is = "insert into ....... values('23/3/2009')" in program time is correct but when i go to sql server,it's show 23/3/2555 when i saw at os is 23/3/2009 i think this problem at sql server but i don't know how to fix it Do you understand me?
View 1 RepliesI have a DateTime field in database and DateTime variable in VB.The VB variable is holding the date as 25/03/2008 11:57but when i save it to DB it changes to 03/25/2008 11:57.What is the solution to this microsoft nightmare.
View 14 RepliesHow do I achieve the same in VB.NET which is so easily done in SQL Server.
Select Case(GetDate() as VarBinary(8)) --Gives the Current Time in Hex
How can I create the same string in VB.NET so that I can compare in SQL Server as such -
Select Case When GetDate()=Cast(0X00009F5E00D8DF7C As DateTime) Then 'True' Else 'False' End -- 0X00009F5E00D8DF7C Will be the value I get in VB.NET When I convert it Date.Now() To Hex
i am having a problem with my date format. i want the format to be MM/DD/YYYY for example 02/28/2011 . i have put custom format in my event. but when i change my setting in regional settings it changes the format
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Myconnection As OleDbConnection
[Code]......
Instead of the send message text box and message display text box, I have replaced it with RichTextBox for text formatting (bold/italics/underline/font/color). The problem I am facing is when I format the text and click on send, then the text displayed on the message display box (txtMessageHistory) is unformatted. [Code] Rest of the code of client is related to formatting of the rich text boxes that is not relevant to my problem. I just need to transfer the formatted text from client to server and then back to the client the same way and display the message with text formatting.
View 13 Replieswould like to send me a pure oop based desktop application developed in vb.net 2008 and sql server 2005?
View 3 RepliesCommand = New OleDbCommand("SELECT dbo.tbl_staff.staff_id, dbo.tbl_staff.username, dbo.tbl_staff.password, dbo.tbl_useraccount.position_id " & _
"FROM dbo.tbl_position INNER JOIN " & _
[code]....
It says incorrect syntax.
I work at a school that utilizes several servers in our network. I wrote a program for a class I was teaching and then they changed the servers so there is a new path to the different components. When I test each component it works correctly but when I try to utilize the menu it utilizes the old path and the programs wont operateSteve.
View 3 RepliesWhen subtracting two doubles the result appears to be correct but when I save said results in a SQL Server table they are incorrect. I know their are problems with decimal values in the binary world but isn't there a work around for this?For example 421.2 - 418.9 = 2.3, but the result stored in the SQL Server table is 2.29!In the VB code I used Math.Round to round to two digits and the values appear correct during debugging but, as I've said, in the end they are off by .01. [code] decimal(10,2)BTW, I've tried numerous methods of getting the correct value but have not met with any success. I've used Math.Round on Val1 and Val2 separately, after the subtraction, and on the ResultVal. I've also converted the ResultVal to a string using Format(ResultVal, "#####.00") and then back to a number but still the value that ends up in the SQL Server table is wrong.
View 5 RepliesI have an application in which I have one textbox (in this one I write a date like 23.07.2010 ) and a combobox in which I insert a time from the list of combobox (like 12:30, 14:45, etc). I want that when I press a button to send this datetime value in a column of an sql database. I want to send something like (in VB.NET)
sql=" INSERT INTO table_name (column1, column2, date_time_column) values ( val1, val2, '23.07.2010 12:30') "
execute(sql)
So, I have problems when I want to send date/time into sql tables because of the different Regional Settings.
Are there any good books out there that will show someone how to set up a form using Visual basic that will take information and send it to the server and then send a recipient an Email?
View 2 Repliesthis code below it gives me this error "error: Incorrect integer value: '' for column 'MPotProspect' at row 1"
[code]...
this give me another error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1/" another way i tried when i highlight the myDatarow.Item(8).tostring and see what is inside there no data found.. but the other from mydatarow 7 to 1 there is data.. but in the database all of the fields including mydatarow(8) has data inside... why in mydatarow(8) when the program run it turn to null... may be the will cause the error...
This code is not giving the msgbox value! Is the GetValue method incorrect?
[Code]...
May I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 RepliesI am trying to use CDO in VBScript to send email from one server to a separate exchange server
View 2 RepliesHow to retrieve the current datetime of Server in LAN?
View 4 RepliesSo I created a table and one of the columns is is called currencydate, and has a datetime data type. Within my vb scripts, i've taken a filename and extracted the date components from it. an example filename is WER22402.10. The part in bold is the date meaning 24th February 2010.
I use the following function to extract the date values and convert it to a date type.
Private Function ConvertStringToDate(ByRef FileName) As Date
Dim S As String = FileName
S = S.Substring(4, 7)
[Code].....
I am trying to update a DateTime object into a datetime field of a sql (SQL Server 2000) database.I have the following function
Public Sub Update(ByVal lastlogin as DateTime)
Using slqupdate as SqlCommand = _connection.CreateCommand()
sqlupdate.CommandType = CommandType.Text
[code].....
how to check the server DateTime when the application launch. i want to make sure the user PC has the same DateTime as server when the user use the application. Reason being is some user may tend to change their DateTime backward and it causes a major confusion when it update in the server database. Below is my code....Both of the code giving problem and does not compare the date time to my pc datetime... how to check the the server datetime is same with the pc server time....
Public Sub GetServerDateTime()
Dim WMIScope As Management.ManagementScope
Dim WMIConnectionOptions As New Management.ConnectionOptions
[Code].....
I am not sure if this should be in the SQL or vb.net section.But, Basically I have a vb.net application from where I insert a datetime field into the SQL Server Database. Now for some reason the SQL server field(which is datetime) will not display AM/PM, I have referred this link where my code looks like this:
Dim dateToDisplay As DateTime = DateTime.Now dsNewRow.Item("date_created") = dateToDisplay.ToString("MM.dd.yyyy hh:mm:ss tt")
I tried stepping into the code by debugging and it seems to be inserting the PM but is not displayed in the table QuotedateToDisplay#8/12/2011 6:01:06 PM#Date
I'm changing old, vulnerable SqlCommands with SqlParameters but get a SqlException: System.Data.SqlClient.SqlException {"Conversion failed when converting datetime from character string."}
on sqlCommand.ExecuteScalar:
Dim sqlString As String = _
"SELECT TOP 1 " & _
"fiSL " & _
"FROM " & _
[Code]...
I'm trying to create an auction site using asp.net. My auction's start date & time and end date & time are stored in my sql server 2008 r2 database as datetime types. I'm using vb.net. I'm trying to create a select statement in which I can query the date and time portion relative to the current date and time (so as to only display current ongoing auctions). I can successfully query the date portion using the Date.Now function, but the time is giving me a hassle. DateAndTime.Now doesn't work. I've even tried to separate the time and date in the database, but I still can't get an effective query. Here are two examples of code which I've tried:
[Code]...
I've a scenario where I've to move data from a Oracle Table to a SQL Server table. The column in Oracle is Timestamp(6) 6 being the precision. Now I cannot send the Oracle Data in string format. I pull the data straight from the Oracle Table, so cannot format it on oracle side. What I can do is format the data using VB6.Format to make it suitable for SQL Server DateTime. I'm doing this for Oracle Date to SQL Server Datetime
View 1 RepliesI've a scenario where I've to move data from a Oracle Table to a SQL Server table. The column in Oracle is Timestamp(6) 6 being the precision. Now I cannot send the Oracle Data in string format. I pull the data straight from the Oracle Table, so cannot format it on oracle side. What I can do is format the data using VB6.Format to make it suitable for SQL Server DateTime. I'm doing this for Oracle Date to SQL Server Datetime. Can something similar be done for timestamp and Datetime.
View 1 RepliesHow can I achieve this. Insert Null Value into SQL Server DateTime Field?
View 5 RepliesI am getting an exception when I run the below VB.NET code to validate a user..The exception says that "Incorrect syntax near variable user" where am I going wrong ?
[Code]....
i have a table where in date column i have datetime datatype..i want to get only time in textbox...but i m getting both date and time by this below code. i m using vs 2005...sql 2005
[Code]...
I want to update the date and time from two separate pickers to my table.My 2 DTPers are bound to a dataset.One is in the Short Format, the other is Time.I have several other bound controls, and I just do a .Update to update my table. I tried just updating the row:
Me.DsTradeShow1.Tables("Tradeshow_Details").Rows(0).Item("Show_Date") = CDate(Me.DateTimePicker15.Text & " " & Me.DateTimePicker16.Text)
but it throws an exception when I do my save.
[code].....
I have the following code:
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[Code]....
When I debug this, I put the line break on that line and look at the Table Value, which shows 0, but I know that there is data for that time frame.