I want to Export Data to Excel from Dataset. I am adding reference to Microsoft Excel object library 5.o, then i am getting only Excel dll to import. and when i am running Application i am getting "can't create ActiveX component" Message.
I have Microsoft Office Professional Edition 2003.
I write code link this way:
Imports Excel
Dim oXL As Excel.Application Dim oBooks As Excel.Workbooks Dim oBook As Excel.Workbook Dim oSheets As Excel.Worksheets Dim oSheet As Excel.Worksheet Dim oCells As Excel.Range Dim iRow As Integer Dim iCol As Integer
With oSheet For iCol = 0 To lobjDs.Tables(0).Columns.Count - 1 .Cells(1, iCol + 1) = lobjDs.Tables(0).Columns(iCol).ColumnName.ToString() Next For iRow = 0 To lobjDs.Tables(0).Rows.Count - 1 For iCol = 0 To lobjDs.Tables(0).Columns.Count - 1 .Cells(iRow + 2, iCol + 1) = lobjDs.Tables(0).Rows(iRow).Item(iCol) --- -----in this line i am getting error description like this way "Expression is a value and therefore cannot be the target of an assignment."
Next iCol Next iRow End With oXL.Workbooks.Close() oXL.Quit() oXL = Nothing
Please any one can help out for me. I think in adding reference i am mistaken. bare my poor english. Thanks in advance.
I want to Export Data to Excel from Dataset. I am adding reference to Microsoft Excel object library 5.o, then i am getting only Excel dll to import. and when i am running Application i am getting "can't create ActiveX component" Message.
I have Microsoft Office Professional Edition 2003.
I write code link this way:
Imports Excel
Dim oXL As Excel.Application Dim oBooks As Excel.Workbooks Dim oBook As Excel.Workbook Dim oSheets As Excel.Worksheets Dim oSheet As Excel.Worksheet Dim oCells As Excel.Range Dim iRow As Integer Dim iCol As Integer
With oSheet For iCol = 0 To lobjDs.Tables(0).Columns.Count - 1 .Cells(1, iCol + 1) = lobjDs.Tables(0).Columns(iCol).ColumnName.ToString() Next For iRow = 0 To lobjDs.Tables(0).Rows.Count - 1 For iCol = 0 To lobjDs.Tables(0).Columns.Count - 1 .Cells(iRow + 2, iCol + 1) = lobjDs.Tables(0).Rows(iRow).Item(iCol) --- -----in this line i am getting error description like this way "Expression is a value and therefore cannot be the target of an assignment."
Next iCol Next iRow End With oXL.Workbooks.Close() oXL.Quit() oXL = Nothing
Please any one can help out for me. I think in adding reference i am mistaken. bare my poor english. Thanks in advance.
When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.
Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!
Design & Accessibility
This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.
Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together
Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET
Posted: 02 Mar 2005 10:20:12 
