PC Review


Reply
Thread Tools Rate Thread

define dataset column for timestamp data type in MS SQL server

 
 
John Yung
Guest
Posts: n/a
 
      28th Nov 2005
All,

What kind of data type should I use to definde a timestamp (row version)
data-type in MS SQL Server for a column in a dataset?

I tried to define it as byte[], but MSDataSetGenerator is giving me the
"unable to convert xml file content to a DataSet" error.

Thanks,

John Yung


 
Reply With Quote
 
 
 
 
Miha Markic [MVP C#]
Guest
Posts: n/a
 
      29th Nov 2005
Hi John,

Go with base64Binary instead.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"John Yung" <(E-Mail Removed)> wrote in message
news:%23MWI%(E-Mail Removed)...
> All,
>
> What kind of data type should I use to definde a timestamp (row version)
> data-type in MS SQL Server for a column in a dataset?
>
> I tried to define it as byte[], but MSDataSetGenerator is giving me the
> "unable to convert xml file content to a DataSet" error.
>
> Thanks,
>
> John Yung
>
>



 
Reply With Quote
 
John Yung
Guest
Posts: n/a
 
      30th Nov 2005
Miha,

Thanks, that works.

JY

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%(E-Mail Removed)...
> Hi John,
>
> Go with base64Binary instead.
>
> --
> Miha Markic [MVP C#]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "John Yung" <(E-Mail Removed)> wrote in message
> news:%23MWI%(E-Mail Removed)...
> > All,
> >
> > What kind of data type should I use to definde a timestamp (row version)
> > data-type in MS SQL Server for a column in a dataset?
> >
> > I tried to define it as byte[], but MSDataSetGenerator is giving me the
> > "unable to convert xml file content to a DataSet" error.
> >
> > Thanks,
> >
> > John Yung
> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to load timestamp type in dataset in oracle and sqlserver =?Utf-8?B?TmFwbw==?= Microsoft ADO .NET 2 6th Sep 2007 05:13 PM
Add a TimeStamp column into a DataSet yachea2002@hotmail.com Microsoft ADO .NET 0 23rd Aug 2004 09:22 PM
Detect each column's data type of SalDataReader, DataSet, DataTable Hardy Wang Microsoft ADO .NET 5 27th Feb 2004 03:48 PM
Detect each column's data type of SalDataReader, DataSet, DataTable Hardy Wang Microsoft C# .NET 5 27th Feb 2004 03:48 PM
SQL Server 2000 Timestamp and Dataset Paolo Taverna Microsoft ADO .NET 0 13th Aug 2003 12:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:58 PM.