Inserting the datetime with milliseconds value into a datarow

[Manikandan]

Hi,
I need to insert the datetime with milliseconds value into a datarow.

My code as below
DataTable testDataTable=n ew DataTable();

testDataTable.C olumns.Add("upd atedDateTime", typeof(DateTime ));

DataRow testDateRow=sur veyUpdatedDateD ataTable.NewRow ();
testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff");
testDataTable.R ows.Add(surveyU pdateDateRow);

when I read the values back using the following code I lose the
millisecond value

for(int testRows=0;test Rows<testDataTa ble.Rows.Count; testRows++)
{

Messagebox.Show (testDataTable. Rows[testRows]
["updatedDateTim e"] .ToString()

}

Any conversion required?
When i give a messagebox for DateTime.Now.To String("yyyy-MM-dd
HH:mm:ss.fff") it is coming properly with milliseconds
I need the datetime values with milliseconds from datatable to insert
into sql server datetime column
Thanks,
Mani

[Nicholas Paldino [.NET/C# MVP]]

Mani,

Why are you calling ToString on the DateTime? Why not just set the
value of the row to the DateTime instance. It should work then, and assign
your datetime appropriately.

Also, are you sure you are using a datetime column and not a
smalldatetime column?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Manikandan " <pl**********@g mail.comwrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.com.. .

Hi,
I need to insert the datetime with milliseconds value into a datarow.

My code as below
DataTable testDataTable=n ew DataTable();

testDataTable.C olumns.Add("upd atedDateTime", typeof(DateTime ));

DataRow testDateRow=sur veyUpdatedDateD ataTable.NewRow ();
testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff");
testDataTable.R ows.Add(surveyU pdateDateRow);

when I read the values back using the following code I lose the
millisecond value

for(int testRows=0;test Rows<testDataTa ble.Rows.Count; testRows++)
{

Messagebox.Show (testDataTable. Rows[testRows]
["updatedDateTim e"] .ToString()

}

Any conversion required?
When i give a messagebox for DateTime.Now.To String("yyyy-MM-dd
HH:mm:ss.fff") it is coming properly with milliseconds
I need the datetime values with milliseconds from datatable to insert
into sql server datetime column
Thanks,
Mani

[Manikandan]

On 9 Jul, 18:08, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail] d.caspershouse. comwrote:

Mani,

Why are you calling ToString on the DateTime? Why not just set the
value of the row to the DateTime instance. It should work then, and assign
your datetime appropriately.

Also, are you sure you are using a datetime column and not a
smalldatetime column?

--
- Nicholas Paldino [.NET/C# MVP]
- [e-mail] .caspershouse.c om

"Manikandan " <plmanikan...@g mail.comwrote in message

news:11******** **************@ q75g2000hsh.goo glegroups.com.. .

Hi,
I need to insert the datetime with milliseconds value into a datarow.

My code as below
DataTable testDataTable=n ew DataTable();

testDataTable.C olumns.Add("upd atedDateTime", typeof(DateTime ));

DataRow testDateRow=sur veyUpdatedDateD ataTable.NewRow ();

testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff");
testDataTable.R ows.Add(surveyU pdateDateRow);

when I read the values back using the following code I lose the
millisecond value

for(int testRows=0;test Rows<testDataTa ble.Rows.Count; testRows++)
{

Messagebox.Show (testDataTable. Rows[testRows]
["updatedDateTim e"] .ToString()

}

Any conversion required?
When i give a messagebox for DateTime.Now.To String("yyyy-MM-dd
HH:mm:ss.fff") it is coming properly with milliseconds
I need the datetime values with milliseconds from datatable to insert
into sql server datetime column

Thanks,
Mani

Hi,
When I assign the datetime, and updating that value into sql server
database table, Milliseconds are set to 000 only
I need to insert that datarow values into a sql server table
column(dat type:datetime)
Could you please tell me how to insert the datetime value with
millisecond from c# to sql server

Thanks,
Mani

[Rad [Visual C# MVP]]

On Mon, 09 Jul 2007 09:57:14 -0700, Manikandan
<pl**********@g mail.comwrote:

>
testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff") ;
testDataTable. Rows.Add(survey UpdateDateRow);

Why don't you do this directly?

testDateRow["updatedDateTim e"]=DateTime.Now

--
http://bytes.thinkersroom.com

[Manikandan]

On 9 Jul, 21:04, "Rad [Visual C# MVP]" <[e-mail] mwrote:

On Mon, 09 Jul 2007 09:57:14 -0700, Manikandan

<plmanikan...@g mail.comwrote:

testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff");
testDataTable.R ows.Add(surveyU pdateDateRow);

Why don't you do this directly?

testDateRow["updatedDateTim e"]=DateTime.Now

--http://bytes.thinkersr oom.com

Hi,
I tried datetime.now.
The millisecond value is 000 for datetime.now.
Then only I used DateTime.Now.To String("yyyy-MM-dd

HH:mm:ss.fff");

Thanks
Mani

[Manikandan]

On 9 Jul, 21:04, "Rad [Visual C# MVP]" <[e-mail] mwrote:

On Mon, 09 Jul 2007 09:57:14 -0700, Manikandan

<plmanikan...@g mail.comwrote:

testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff");
testDataTable.R ows.Add(surveyU pdateDateRow);

Why don't you do this directly?

testDateRow["updatedDateTim e"]=DateTime.Now

--http://bytes.thinkersr oom.com

Hi,
I have table in sql server 2000
Table name:date_test
Column name datatype
no int
date_t DateTime
I tried the following code
DataTable dt1 = new DataTable();
dt1.Columns.Add ("no",typeof(Sy stem.Int16));
dt1.Columns.Add ("date_t", typeof(System.D ateTime));
DataRow dr = dt1.NewRow();
dr["no"] = 1;
dr["date_t"] = DateTime.Now;
dt1.Rows.Add(dr );
for(int i=0;i<dt1.Rows. Count;i++)
{
string str=dt1.Rows[i]["no"].ToString();
DateTime dt=(DateTime)dt 1.Rows[i]["date_t"];
string insertQuery = "insert into date_test values(" +
str + ",'" + dt + "')";
SqlCommand cmd = new SqlCommand(inse rtQuery,
connectionToDat abase);
cmd.ExecuteNonQ uery();
MessageBox.Show ("saved");
}
After inserting the record from C#, I checked the table in sql server,
the milliseconds are stored with 000 i.e(2007-07-09 21:31:32 000)
I want the datetime value with milliseconds
How to insert a datetime value into sql server?
Thanks,
Mani

[John Vottero]

"Manikandan " <pl**********@g mail.comwrote in message
news:11******** **************@ g4g2000hsf.goog legroups.com...

On 9 Jul, 21:04, "Rad [Visual C# MVP]" <[e-mail] mwrote:

>On Mon, 09 Jul 2007 09:57:14 -0700, Manikandan

<plmanikan...@ gmail.comwrote:

>testDateRow["updatedDateTim e"]=DateTime.Now.T oString("yyyy-MM-dd
HH:mm:ss.fff") ;
testDataTable. Rows.Add(survey UpdateDateRow);

Why don't you do this directly?

testDateRow["updatedDateTim e"]=DateTime.Now

--http://bytes.thinkersr oom.com

Hi,
I have table in sql server 2000
Table name:date_test
Column name datatype
no int
date_t DateTime
I tried the following code
DataTable dt1 = new DataTable();
dt1.Columns.Add ("no",typeof(Sy stem.Int16));
dt1.Columns.Add ("date_t", typeof(System.D ateTime));
DataRow dr = dt1.NewRow();
dr["no"] = 1;
dr["date_t"] = DateTime.Now;
dt1.Rows.Add(dr );
for(int i=0;i<dt1.Rows. Count;i++)
{
string str=dt1.Rows[i]["no"].ToString();
DateTime dt=(DateTime)dt 1.Rows[i]["date_t"];
string insertQuery = "insert into date_test values(" +
str + ",'" + dt + "')";

You're losing the milliseconds here because you're converting the Datetime
into a string. Pass the Datetime to SQL using a SqlParameter and
parameterized SQL. Add the paramters to the SqlCommand with code like:

cmd.Parameters. Add(new SqlParameter("@ dtName", dt));

Then, refer to the "@dtName" parameter in your Sql like:

string insertQuery = "insert into date_test values(@strName ,
@dtName)";
See http://msdn2.microsoft.com/en-us/lib...2(sql.80).aspx for more
information.

SqlCommand cmd = new SqlCommand(inse rtQuery,
connectionToDat abase);
cmd.ExecuteNonQ uery();
MessageBox.Show ("saved");
}
After inserting the record from C#, I checked the table in sql server,
the milliseconds are stored with 000 i.e(2007-07-09 21:31:32 000)
I want the datetime value with milliseconds
How to insert a datetime value into sql server?
Thanks,
Mani