If you want to read another post of mine regarding XML Literals click here. In order to follow along you must have all the above running smoothly in your pc.It will be great for you in order to better understand what I am about to show you, If you are familiar with LINQ to SQL and XML Literals.
I have attached the Pubs database in my local instance of the SQL Server. SQL Server 2008/2005 Express editions will work just fine.You can download SQL Server 2008 Express edition from this link. I have installed SQL Server 2008 Standard edition in my PC. If you need some help on how to install the database have a look here. This is a well known database and many people are familiar with its schema.You can download the Pubs database from this link.
Obviously for this example we will need a database. I am going to use Visual Studio 2008 professional but Visual studio 2008 Express edition will do just fine.You can download Visual Studio 2008 from here. So I will try to show all these, by (a hands-on example) building a windows form application using VB 2008(9.0). I tried to help him out and then thought that it might be a good idea to write a post about the solution I proposed.
Another thing to bear in mind here is that we needed to create the excel file programmatically. Yes it is, but the concepts are rather easy and I have been posting lots of stuff regarding LINQ to SQL,VB.Net, XML Literals, e.t.c.Ī friend of mine had a project which required to get some data from an SQL Server database table, create an XML document from the relational data and import it to an excel file. You must think that this post title is a rather long one. Tags: Excel, Linq to Sql, VB 9.0, Visual Studio 2008, XML, XML Literals Create an XML file using LINQ and import XML data into an Excel spreadsheet MaPosted by fofo in LINQ, MS Office, VB 9.0, Visual Studio 2008.
0 kommentar(er)
