Re: read excel file loaded in memory - C# Discussion Boards

OnLeave event is not firing !?

10-May-07 1:47

Hello,

System.IO.Path has a lot of fancy methods like:
string extension = System.IO.Path.GetExtension(filename);

All the best,

Martin

Re: txText control

Giorgi Dalakishvili10-May-07 1:54

Giorgi Dalakishvili

10-May-07 1:54

You can check for extension of openFileDialog1.FileName Smile | :)

Re: [Message Deleted]

Colin Angus Mackay10-May-07 2:01

Colin Angus Mackay

10-May-07 2:01

Don't delete your question - It is considered rude.

Upcoming events:
* Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

kumar.bs10-May-07 1:16

kumar.bs

10-May-07 1:16

I am having a strange experience. I have inherited a grid class and written my own class, say myGrid. Now, i am wrapping myGrid object in myPresentationControl class.

when i set the visibility of myPresentationControl object , sometimes OnLeave event of myGrid is firing and sometimes not, any idea what could be the reason?

Thanks
kumar

Re: OnLeave event is not firing !?

Martin#10-May-07 1:49

read excel file loaded in memory

10-May-07 1:49

Hello,

Maybe it depends on if the Grid has focus or not?

All teh best,

Martin

haytham_mohammad10-May-07 1:09

haytham_mohammad

10-May-07 1:09

hi
we have an excel file opened and contain data, this file is not saved on the hard i want to read the data of this excel file while it i opened in memory
i don`t want to save the file the read it using it`s path i want to read it from the memory

how can i do that

thanks in advance,

haitham

Re: read excel file loaded in memory

led mike10-May-07 5:13

led mike

10-May-07 5:13

I don't know if that is possible but if it is you would use the Excel Object Model from the Primary Interop Assembly. If you go search on MSDN you can find all sorts of information about it. The namespace is: Microsoft.Office.Excel

led mike

Files size?

Muammar©10-May-07 0:50

Muammar©

10-May-07 0:50

Hi, any idea how to calculate files size found in some folder??

string[] arSourceFiles = System.IO.Directory.GetFiles(MyDir);
arSourceFiles.(:confused:);

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Mandaar Kulkarni10-May-07 1:00

Mandaar Kulkarni

10-May-07 1:00

Try This....

foreach (string file in arSourceFiles)
{
FileInfo finfo = new FileInfo(file);
int filesize = finfo.Length; // Length returns the size of file.
}

Muammar©10-May-07 1:43

Muammar©

10-May-07 1:43

Looks good enough Smile | :)

thank you Mandaar Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Martin#10-May-07 1:55

10-May-07 1:55

Hello,

If you also whant to look in the folders of you main folder, you have to go threw it recursive!

Like this:

private double GetFileSize(DirectoryInfo di, double currentsize)
{
    double actsize = currentsize;
    FileInfo[] AllFiles = di.GetFiles();
    DirectoryInfo[] AllDirectories = di.GetDirectories();

    foreach(FileInfo fi in AllFiles)
    {
        actsize = actsize + fi.Length;
    }

    foreach(DirectoryInfo dinew in AllDirectories)
    {
        actsize = GetFileSize(dinew, actsize);
    }

    return actsize;
}

I think there is some feature in .Net >1.1 which does that.

Hope it helps!

All the best,

Martin

szukuro10-May-07 2:48

szukuro

10-May-07 2:48

Martin# wrote:
I think there is some feature in .Net >1.1 which does that.

Actually it's just a new overload for the GetFiles method.
http://msdn2.microsoft.com/en-us/library/ms143327(vs.80).aspx[^]

Martin#10-May-07 2:53

Merging DataSets and committing changes + help please.

10-May-07 2:53

Yep, Thanks for the info

Naveed Kamboh10-May-07 0:27

Naveed Kamboh

10-May-07 0:27

Hi Friends,
I want to merge to dataset i.e ds1 into ds2 and commit changes in ds2.
I managed to merge but its not commiting changes
Any help Please?

Naveed Kamboh
Complexity kills, Write easy code for your self.
Cash-time

Re: Merging DataSets and committing changes + help please.

Muammar©10-May-07 0:52

Muammar©

10-May-07 0:52

Try this.

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Merging DataSets and committing changes + help please.

Naveed Kamboh10-May-07 1:25

Naveed Kamboh

10-May-07 1:25

I guess I didn't explain my problem v.well.

Basicaly i have 2 data bases each datbase got 1 table with same schema.

first database table has got 20 rows while 2nd Database has got 5 records

I want to insert other 15 records from first database to 2nd database

I opened two connection connectino 1 and Connection with databaeses respectively and filled 2 DataSets ds1 and ds2 respectively.

I am merging datasets as
ds2.Merger(ds1);

its showing 20 records in ds2 also but its not updating those records in Databaset it showin in debugging mode only.

How can I update those to database. thanks.

Naveed Kamboh
Complexity kills, Write easy code for your self.
Cash-time

Error in using CrystalReportViwere Control!

dina_aqua10-May-07 0:21

dina_aqua

10-May-07 0:21

Deer All,

I have created a windows application using C# .NET 2005 and I used Crystal Report Viewr to view three kinds of reports according to different criterias. The starange thing is that the application ran without errors for some days and after that the following error appear and I try to fix it by all things I thought about without any change.

The exception is: Cry | :((

" The type initializer for 'CrystalDecisions.ReportSource.ReportSourceFactory' threw an exception. "

Please, help me as I think later to use Reporting Server instead of Crystal Report but this will be waste for time whitch is the most invaluable thing.

Thanks alot for cutting your valuable time.

Dina A.H
Software Developer

Highlight button

immu510-May-07 0:19

immu5

10-May-07 0:19

I have two radiobuttons of same group and three buttons back, next and cancel in the same order. if i check any of the radiobuttons, back button is highlighting. i want Next button to be highlighted.i.e Focus should be on Next button.
Any solutions??

Imran.

Re: Highlight button

Mandaar Kulkarni10-May-07 0:38

Mandaar Kulkarni

10-May-07 0:38

Try setting focus mannually in the Click event or CheckedChanged event of the radio button using BtnNext.Focus()

Insert record and get it's ID

blackjack215010-May-07 0:02

blackjack2150

10-May-07 0:02

Hi.

I want to insert a record in a table and then get it's ID(which is an autonumber field) to use it as a reference in another table. What is the best approach?

Thanks.

Colin Angus Mackay10-May-07 0:08

Colin Angus Mackay

10-May-07 0:08

blackjack2150 wrote:
I want to insert a record in a table and then get it's ID(which is an autonumber field) to use it as a reference in another table. What is the best approach?

What is the database?

tcss10-May-07 0:26

tcss

10-May-07 0:26

If this is a MS-SQL database Ive gotten this to work by using a stored procedure and returning @@IDENTITY from the stored proc.

The only other way I know of is to timestamp the record at the time of writing and return the record with that timestamp(or some other form of identifying field) in a query statment.

blackjack215010-May-07 0:27

blackjack2150

10-May-07 0:27

Let's continue on the database forum.
This topic can now be deleted by the admin.
Thanks.