ASP.NET 2 Data Binding with SQL 2005 XML

[Greg Collins [Microsoft MVP]]

I am starting a project where I will be using the XML data type in SQL Server 2005, and ASP.NET to display and update the content of the XML.

I've been digging around for a bit trying to find some sources that will explain the process of doing data binding in ASP.NET with the SQL XML, but haven't been able to locate anything too useful yet.

The XML will be charts, each holding 3 groups of 70 rows of data, each row having 5 fields (boolean, datetime, datetime, int, string).

I will need to pull 1 or more charts down to be rendered in a web page, modified, and then stored back to SQL.

I'm assuming from what I've read so far that this is possible, but I need more information and hopefully some examples.

I've worked somewhat with SQL 2000 and ASP.NET 2 (mostly hand-written pages), but want to get full bore into using VS2005 to do this. I am very familiar with XML, XSLT, HTML, C# and JavaScript, moderately familiar with SQL and VS.

Any leads to web sites and books that would help along these lines would also be appreciated.
--
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )

[Alexey Smirnov]

On Mar 21, 6:15 pm, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_comwrote:

I am starting a project where I will be using the XML data type in SQL Server 2005, and ASP.NET to display and update the content of the XML.

I've been digging around for a bit trying to find some sources that will explain the process of doing data binding in ASP.NET with the SQL XML, but haven't been able to locate anything too useful yet.

The XML will be charts, each holding 3 groups of 70 rows of data, each row having 5 fields (boolean, datetime, datetime, int, string).

I will need to pull 1 or more charts down to be rendered in a web page, modified, and then stored back to SQL.

I'm assuming from what I've read so far that this is possible, but I need more information and hopefully some examples.

I've worked somewhat with SQL 2000 and ASP.NET 2 (mostly hand-written pages), but want to get full bore into using VS2005 to do this. I am very familiar with XML, XSLT, HTML, C# and JavaScript, moderately familiar with SQL and VS.

Any leads to web sites and books that would help along these lines would also be appreciated.

--
Greg Collins [Microsoft MVP]
Visit Braintrove (http://www.braintrove.com)

Work with XML Data Type in SQL Server 2005 from ADO.NET 2.0
http://www.developer.com/net/net/article.php/3406251

XML data type tips in SQL Server 2005
http://www.codeproject.com/dotnet/XMLdDataType.asp

and...
http://www.google.com/search?hl=en&q...L+2005+asp.net