Browse by Tags

Home ›

All Tags » excel » ADO.NET (RSS)

reading excel file, merged cells

hello Please check the sample excel sheet I intend to use to get a clear understanding of my question I need to use datareader to query using a sql statement to retrieve data from the woksheet. I have seen many examples on how to do this but all those consider the first row (Row 1 in spreadsheet) to...

Posted to Other Databases (Forum) by azhar2000s on 11-13-2008, 12:00 AM
Filed under: ADO.NET, ASP.NET, Data Access, Excel
Excel Import Issue

Hi, so i have the following problem. I need to be able to import an excel file into a sql database. The excel file should be uploaded, but that is not the issue here. The issue is the following: The c# code just wont read the whole excel file. It pretty much always ignores the last 3 columns if i use...

Posted to Data Access and ObjectDataSource Control (Forum) by toby_berster on 01-21-2008, 12:00 AM
Filed under: ADO.NET, Excel
retriving data from Excel sheets to .aspx page grid view

i am getting an error that in the connection strings i hve added the reference to the com library. my code file as follows .xls file contains in the App_Data Directory. 2) The search button is disabled when i run the application but the visible property is set to TRUE Error: Error 1 'System.Configuration...

Posted to Data Presentation Controls (Forum) by rajuonline_531 on 10-12-2007, 12:00 AM
Filed under: reflection, selectedindex gridview, "gridview" edit select eventhandling, .Net 2.0, .NET Gridview Problems, AccessDataSource, ADO.NET, advanced, asp, asp .net 2.0, asp net 2.0 gridview objectdatasource dynamic runtime, asp net datalist, asp net grid view error, ASP.NET 2.0 DataBinding DefaultView, asp.net 2.0 DataBinding javasript, ASP.NET 2.0 GridView databound, asp.net 2.0 GridView databound codebehind ItemTemplate Zimmergren :), ASP.NET 2.0 GridView databound error data, ASP.NET 2.0 GridView SelectedValue, ASP.net 2.0 GridView with checkboxs, ASP.NET 2.0 webform, C# 2005 Gridview, C# SQL Server Photo Gallery Images, Databind(), datagrid property, dropdownDownList in grid view, dropdownList gridview, Dropdownlist SQL Dynamic, Excel import ssl, executereader, export csv, export excel, export excel gridview images image jpg jpeg save as, Export GridView to Excel, export to excel, Export to Excel not working with 2007, gridview dropDownList selected listitem, GridView selected Item, gridview selectedIndexChanged problem solution, gridview selectedvalue, HTML, HTML tags grid gridview, HtmlTextWriter, Detailsview dropdown problem, detailsView edit textbox width, DetailsView InsertItemTemplate textbox identity user, gridView update sqldatasource, grid view details view, asp .net ... c# ... SQL javascrpt, Excel, excel C#, Excel Datagrid
How to copy data from one excel file to other excel file

Hi I have two excel file (Ex1 and Ex2), both have same template (headers) and data will be populated from the dataset. Upto this step its works fine. My question : How to copy the data form 6th row to last row of "Ex2" and paste it into the "Ex1" after the last row in Ex1. Advance...

Posted to Enterprise Services Integration (Forum) by SudhaYogesh on 09-12-2007, 12:00 AM
Filed under: postback variables, querystring, selection, sql, sqldatabase, t code behind, update, VB.Net, ado.net, asp, ASP.NET, Asp.Net 1.1, Asp.Net 2.0, Asp.Net 2.0 and MS SQL Server 2005, asp.net 2.0 asp.net, asp.net 2.0 export to excel, Asp.Net 2.0 session, ASP.net 2.0 Tutorials, ASP.NET Sites, ASP.NET.NET 2.0, c#, C# code, database, datareader, dataset, datasource, excel, GridView field, Asp.NET2.0, grid view, reports, DotNet, Find Control
Excel to Sql

Hi Thnks for the time I was trying to figure out how to insert the data that I read from an excel sheet into multiple tables in SQL Database 2005. // Connection string to the excel file string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source= D:\\UserData.xls;"...

Posted to Data Access and ObjectDataSource Control (Forum) by Poise on 05-25-2007, 12:00 AM
Filed under: ADO.NET, DataSet, Excel
Adding excel to an existing table

Hi all I am trying to add some data from an excel file to my db. To do so, I first load the existing data from the table in an objectdatasource object, that is bound to a gridview control. Then I get access to the excel file using ADO.NET ( "Provider=Microsoft.Jet.OleDb.4.0; data source=" & Me .filePath...

Posted to Data Access and ObjectDataSource Control (Forum) by sra on 01-12-2007, 12:00 AM
Filed under: object data source, ADO.NET, Excel
Re: Manipulating a Gridview once imported into Excel

you could use ADO.NET and connect to the spreadsheet. The following link explains how to connect and run select, update, insert, and delete statements against the spreadsheet with ADO.NET. http://support.microsoft.com/kb/316934

Posted to Data Presentation Controls (Forum) by charles.w.lambert@gmail.com on 03-04-2009, 12:00 AM
Filed under: ADO.NET, Excel
Open and Read four column and calculate one column in an Excel Spreadsheet

there are five columns(A,B,C,D,F) in Excel (.XSL) file. I want to read four columns(A,B, c,D), then calculate F =A+ B+ C +D, after that. insert the F value into F column, and save it. any thought will be big help. Thanks.

Posted to Getting Started (Forum) by hong_ma on 02-13-2008, 12:00 AM
Filed under: ADO.NET, c# in Asp, Excel
Re: Export Report to Excel Workbook, not individual Excel Sheet

Hi, You can use ADO.Net to export to your data to Excel Sheet based on the Sheet Name. In this way you can have different sheets with different data in the same Excel WorkBook Thanks Mudassar

Posted to Web Forms (Forum) by mudassarkhan on 12-06-2008, 12:00 AM
Filed under: ADO.NET, excel

Page 1 of 1 (9 items)

Browse by Tags

Related Posts