Click here to Skip to main content
15,905,612 members
Home / Discussions / C#
   

C#

 
QuestionIs their a better way than using the Try/Catch statement in this source? Pin
venomation1-Dec-09 9:07
venomation1-Dec-09 9:07 
AnswerRe: Is their a better way than using the Try/Catch statement in this source? Pin
OriginalGriff1-Dec-09 9:15
mveOriginalGriff1-Dec-09 9:15 
GeneralRe: Is their a better way than using the Try/Catch statement in this source? Pin
venomation1-Dec-09 9:24
venomation1-Dec-09 9:24 
GeneralRe: Is their a better way than using the Try/Catch statement in this source? Pin
OriginalGriff1-Dec-09 9:34
mveOriginalGriff1-Dec-09 9:34 
GeneralRe: Is their a better way than using the Try/Catch statement in this source? Pin
vtchris-peterson1-Dec-09 9:29
vtchris-peterson1-Dec-09 9:29 
GeneralRe: Is their a better way than using the Try/Catch statement in this source? Pin
venomation1-Dec-09 9:37
venomation1-Dec-09 9:37 
QuestionSandboxing with AppDomain Pin
softwarejaeger1-Dec-09 7:51
softwarejaeger1-Dec-09 7:51 
QuestionReading excel file in Vista x64 Pin
kmuthuk1-Dec-09 5:38
kmuthuk1-Dec-09 5:38 
I'm trying to read an Excel file in C# Visual Studio 2008 using oldDb. My connection gets opened successfully, but oldDb adapter doesn't fill the datatable.

Here is my code:

private void openExcel()
{
            string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=""C:\MyLocation\myFile.xls"";Extended Properties=""Excel 12.0;HDR=NO;""";
            OleDbConnection excelConnection = new OleDbConnection(connectionString);
            excelConnection.Open();

            string strSQL = "SELECT * FROM [Sheet1$]";

            OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);

            // create data table
            DataTable dTable = new DataTable();
            dataAdapter.Fill(dTable);

            aListBoxControl.DataSource = dTable;

            // dispose used objects
            dTable.Dispose();
            dataAdapter.Dispose();
            dbCommand.Dispose();

            excelConnection.Close();
            excelConnection.Dispose();
        }

Could anyone please help me find this?

Thanks in advance.
AnswerRe: Reading excel file in Vista x64 Pin
Dave Kreskowiak1-Dec-09 5:47
mveDave Kreskowiak1-Dec-09 5:47 
GeneralRe: Reading excel file in Vista x64 Pin
kmuthuk1-Dec-09 5:55
kmuthuk1-Dec-09 5:55 
GeneralRe: Reading excel file in Vista x64 Pin
Dave Kreskowiak1-Dec-09 11:04
mveDave Kreskowiak1-Dec-09 11:04 
QuestionWrapped COM call works during Test, otherwise fails Pin
puromtec11-Dec-09 5:18
puromtec11-Dec-09 5:18 
AnswerRe: Wrapped COM call works during Test, otherwise fails Pin
Paulo Zemek1-Dec-09 6:07
Paulo Zemek1-Dec-09 6:07 
GeneralRe: Wrapped COM call works during Test, otherwise fails Pin
puromtec11-Dec-09 6:31
puromtec11-Dec-09 6:31 
GeneralRe: Wrapped COM call works during Test, otherwise fails Pin
Paulo Zemek1-Dec-09 8:06
Paulo Zemek1-Dec-09 8:06 
GeneralRe: Wrapped COM call works during Test, otherwise fails Pin
puromtec11-Dec-09 8:45
puromtec11-Dec-09 8:45 
Questionhelp me to calculate the CRC!! Pin
frommi1-Dec-09 5:04
frommi1-Dec-09 5:04 
AnswerRe: help me to calculate the CRC!! Pin
Cracked-Down1-Dec-09 7:13
Cracked-Down1-Dec-09 7:13 
GeneralRe: help me to calculate the CRC!! Pin
harold aptroot1-Dec-09 7:24
harold aptroot1-Dec-09 7:24 
QuestionHow to make single instance? Pin
RanaSohail1-Dec-09 3:54
RanaSohail1-Dec-09 3:54 
AnswerRe: How to make single instance? Pin
mrcooll1-Dec-09 4:00
mrcooll1-Dec-09 4:00 
AnswerRe: How to make single instance? Pin
PIEBALDconsult1-Dec-09 4:14
mvePIEBALDconsult1-Dec-09 4:14 
GeneralRe: How to make single instance? Pin
RanaSohail1-Dec-09 4:24
RanaSohail1-Dec-09 4:24 
GeneralRe: How to make single instance? Pin
S. Brozius1-Dec-09 4:33
S. Brozius1-Dec-09 4:33 
GeneralRe: How to make single instance? Pin
David Skelly1-Dec-09 4:34
David Skelly1-Dec-09 4:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.