i hv field Pdate in database n datatype is datetime.
i used Ajax Calander Extender in which the code is below:
[Code]....
so,Date inserted in database is like "11-04-2010 00:00:00".
My prob. is that in which i want to remove time 00:00:00 when i insert date in database.
I want to store only date like "11-04-2010" in database.
i hv a table in ms-access that have a column in datetime format.when i add data to this field it get stored in the format dd/mm/yy with time as 12.00.00 am.i m binding this data in grid view.hw can i remove the time from the date as i dont wanna show time in the that column of grid view. i m binding the data in gridview by the template field binding methods
View 6 RepliesI have SQL2012 database, which has a Table with many columns in it . One of the columns is "Start Date" and i set the dataType to "Date". Now I am putting the data into a gridview but the data is different to the database, the "Start Date" column has time as well. why this is happening ( the Start Date column is the gridview is a BoundField).
View 1 RepliesI am filtering dataview using my Date Column but the result is not proper because the Field value also stores time, so I want to convert this Date Field to only Date during Filter. How can I achieve this? Here is my code. And the actual value I am getting in the Dataset Field "CreationDate" is a DateTime field which is like
2010-01-21 14:35:25.203
2010-01-22 12:55:18.033
2010-01-26 12:10:06.990
But I only want to neglet time value and want to compare Date only.
[Code]....
[Code].....
and user3 duplicate more time as the table can i remove duplicate data
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
I'm trying to set the "time" value stored in a date time field, in other words, I want to change the value
05-13-2010 08.47.34
to
05-13-2010 00.00.00
or
05-13-2010 23.59.59
What statement would I use to accomplish this?
Everytime I enter a data in mssql server 2005 using a datepicker for example, this "12:00:00 AM" is entered also. How can i remove it?
Likewise, when I enter a time value, ex. 4:00:00 PM, a date is also entered.. How can I get rid of those? what i need is the time or the date only.
i have date column in my database that is that save date and time toghether i need saving date and time in my database .
now i want show date column in my gridview but i dont want it show the time i want it show just date how i can do it?
how do i insert date and time together ? what is the format for this. i tried like this but its not working.
string startDtime = TextFromDate.Text + " " + Stime;
sql_comm.Parameters.AddWithValue("@StartDate",
DateTime.Parse(startDtime));
is this the right way ? dd/mm/yyy +" "+ 00:00
or i need to make a string that contain this : dd/mm/yyy00:00
its not writing any eror it just do nothing .
I want to filter a datetime field for a date without the time...
I want all fields that contain the selected date regardless of the time.
What should I use as the filter expression?
How can I update a table with current date and time using sqldatasource control?
View 2 RepliesI have a Document name column with varbinary(max) type column in my table
first time when i upload document i am storing doc as a byte array
Dim fs As Stream = Me.fileupload1.PostedFile.InputStream
Dim br As New BinaryReader(fs)
Dim bytes As Byte() = br.ReadBytes(fs.Length)
in my application i have remove atttachmentDoc button, i want to remove uploaded doc from db
so when i pass like this to my storedprocedue
Dim obj As New cls1
Dim bData() As Byte = New Byte(0) {}
bData=nothing
With obj
Dim dt As DataTable = Read_Doc()
If dt.Rows.Count > 0 Then
If Not IsDBNull(dt.Rows(0)("Document")) Then
.Document = bData
.Document_extension = ""
.Remove_Attachment(Me.Selected_ID)
End If
End If
End With
i got error
dbAccess.executeQuery: Procedure or function 'SP_DML1' expects parameter '@Document', which was not supplied.
I'm trying to combine a date and time from separate variables in my asp.net insert sql. pointers? I'm getting the following error
Conversion failed when converting date and/or time from character string.
[Code]....
we are using transactional replication on an sql 2008 server. we try now to add a table to the replication that only consists of 1 culomn of type date and we insert the dates to the table. when we then create the replication we are getting an error on the creation of the snapshot. here is the create table with the insert dates:
USE [Product]
GO
/****** Object: Table [TimeSlices].[BaseDate] Script Date: 05/03/2010 15:52:24 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TimeSlices].[BaseDate]') AND type in (N'U'))
DROP TABLE [TimeSlices].[BaseDate]
GO
USE [Product]
GO
/****** Object: Table [TimeSlices].[BaseDate] Script Date: 05/03/2010 15:52:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TimeSlices].[BaseDate](
[TargetDate] [date] NOT NULL,
CONSTRAINT [PK_BaseDate] PRIMARY KEY CLUSTERED
(
[TargetDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO [TimeSlices].[BaseDate] SELECT TargetDate FROM [TimeSlices].UDF_GetTravelDateRange(GETDATE()-2 , GETDATE()+1000)
attached is the UDF:
[Code]....
this is the add article:
use [Product]
exec sp_addarticle @publication = N'Product$(QuoteNumber)', @article = N'BaseDate', @source_owner = N'TimeSlices', @source_object = N'BaseDate', @type = N'logbased', @description = null, @creation_script = null, @pre_creation_cmd = N'drop', @schema_option =
0x000000000803509F, @identityrangemanagementoption = N'manual', @destination_table = N'BaseDate', @destination_owner = N'TimeSlices', @vertical_partition = N'false', @ins_cmd = N'CALL sp_MSins_TimeSlicesBaseDate', @del_cmd = N'CALL sp_MSdel_TimeSlicesBaseDate',
@upd_cmd = N'SCALL sp_MSupd_TimeSlicesBaseDate'
GO
this is the error we get:
Message: Query for data failed
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause,
Boolean useTableLockHint, Int32 bcpFileFormatVersion)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Message: Conversion failed when converting date and/or time from character string.
Stack: (Source: MSSQLServer, Error number: 241)
why we are getting the conversion error on the snapshot creation?
In short, I have 3 text box fields on an .aspx page named as follows:-
TextBoxIncident
TextBoxDate
TextBoxDescription
in addition a sql datasource is on the page which is connected to the incident table with an insert query which allows the data entered into the fields to be inserted into the database...
The Textboxincident and textboxdescription fields allow the user to enter data into them...
the TextBoxDate field is a read only and the code behind file enables the text box to show the current date and time the code im using is shown below...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim TextBoxDate As TextBox
TextBoxDate = FormView1.FindControl("TextBoxDate")
TextBoxDate.Text = DateTime.Now
End Sub
When run in browser the textboxdate field shows the current date and time...and Once the textbox incident and text box description fields have been filled in and the submit button is clicked, the fields should be bound to MS SQL table called Incident. This did work before, however it as suddenly stopped working and now displays the following message to me:-
Arithmetic overflow error converting expression to data type datetime. The statement has been terminated.
iI am using Two textboxes and one button.one textbox is for Fromdate and Another textbox is for Todate.i am selecting date from textboxes using Ajex calenderExtender.i want to insert every date(Fromdate to Todate) in database on button click.Example Like:i select 12/30/2010 (MM/DD/YYYY) in FromDate textbox and 01/05/2011 (MM/DD/YYYY) in Todate text box. Now i want to insert these dates
12/30/2010
12/31/2010
01/01/2011
01/02/2011
01/03/2011
01/04/2011
01/05/2011
in database on button click how to insert eveydate in database?
I am pulling a date from an Access Database and inserting into my Dataset. I am assigning it to "myDate" and then assigning it to my SQL parameter @StartDate.
When I run my ExecuteNonQuery I get a null value in my SQL database. There are no null values in my access database. I must have the syntax wrong.
[Code]....
On a test page, I successfully created a google map that pulls both marker and infoWindow information from an XML file. I did this just to get a feel for working with the API. It works fine. However, I do have a SQL database that has this information in it already. This database is updated behind the scenes regulary via a webservice.
I would like to try pulling the map information from my SQL database instead so I don't have to hand maintain the .xml file. The dabase alread has the lat/long information needed for markers. What is the easiest way for me to get that data from the SQL database? Is there a way to run a query and use the data, or will I need to run the query and somehow have it write/update my .xml file for me?
I'm working on a blog and want to show my posts in eastern time zone. i figured that storing everything UTC would be the proper way. This creates a few challenges though:I have to convert all times from UTC to Eastern. This is not a biggie but adds a lot of code.And the "biggie" is that I use a short-date time to reference the posts by passing in a query, ala blogger. The problem is that there is no way to convert the short date time to the proper UTC date because I'm lacking the posted time info.
View 4 RepliesI use a calendar to pick a date that I want to store in my MSSQL Database. I use the form format, like 2010-01-27 (european date format) with no time info. What MS SQL Date-type should I store this date in?
View 4 RepliesI am selecting time from dropdownlist. and want to convert it in datetime and store it in database. When I am converting it to Datetime using following statement.
DateTime start_Time = Convert.ToDateTime(start_ts);
but it is showing as : date:12:00:00AM
I need to store time in database and then show in using gridview.I wonder how to store and show data so that user will see correct datetime depanding on his timezone?
View 6 RepliesI am trying to get the current date and time value updated into a database. I am getting an error when trying to do so though. Here is my code:
[Code]....
Does anyone see anything that throws a red flag?
By using the following code, i save the dateandtime to my MSSQL DB .
Code:
Dim dateTimeToConvert As New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second, Now.Minute, DateTimeKind.Utc)
Dim easternTime As DateTime = TimeZoneInfo.ConvertTime(dateTimeToConvert, easternZone)
Dim nowtime As DateTime = easternTime.ToUniversalTime
TIMESTAMPSqlDataSource1.InsertParameters("datee").DefaultValue = nowtime
TIMESTAMPSqlDataSource1.insert()
In the DB it saves the time as 21:.... but when I view the time using a gridview it shows 1:... (the correct time I want to show is the 1:... )
HTML Code:
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
[Code] ....
I'm not sure why i'm getting two different dates?