C# Discussion Boards - CodeProject

Stefan Troschuetz7-May-07 1:08

7-May-07 1:08

A foreach statement should not be used to change the content of a collection, so replacing it with a for-loop should solve the problem. However, the easiest way would be calling RemoveAll.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

books on c# 2

mahmoud mohammed7-May-07 0:16

mahmoud mohammed

7-May-07 0:16

how to find ebook on c#2 ?

Re: books on c# 2

Colin Angus Mackay7-May-07 0:25

Colin Angus Mackay

7-May-07 0:25

A lot of books these days come with a CD in the back with the ebook version.

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

Re: books on c# 2

Sandeep Akhare7-May-07 0:34

Sandeep Akhare

7-May-07 0:34

Best one is MSDN try to get MSDN for VS 2005 if you know some what DOt Net

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: books on c# 2

Christian Graus7-May-07 2:24

Christian Graus

7-May-07 2:24

Generally, there are two ways.

1 - buy the book
2 - steal the book from a website full of illegal e-books.

I recommend way# 1.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: books on c# 2

Dave Kreskowiak7-May-07 5:23

Dave Kreskowiak

7-May-07 5:23

I needed a good laugh today.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: books on c# 2

Vega027-May-07 6:33

Vega02

7-May-07 6:33

You could always go to your local library and borrow an actual book - and hey, it's free! Big Grin | :-D

May I suggest Pro C# 2005 and the .NET 2.0 Platform, Third Edition[^]? The linked site also offers it as an eBook for USD 30.

Reading Excel Sheets in C#

meeram3957-May-07 0:09

meeram395

7-May-07 0:09

Hi,

I have an requirement to read the data from excel sheets. Excel work book contains 5 sheets. Each day I have to read 5 different sheets. How should I code so as to read a particular sheet on each day(for eg: Monday - Sheet1; Tuesday - Sheet 2 like that). And also I need only to read the values from one colum, say column C.

Also, there are chances the sheets gets updated by the users often. So can I read the data eventhough the file is open?

Any help in this regard will be great. Please provide the code, if possible.

The application is in C# and I'm using VS.Net 1.1

Meeram395

Re: Reading Excel Sheets in C#

blackjack21507-May-07 0:15

blackjack2150

7-May-07 0:15

This is a component which makes working with excel files easier:

http://www.gemboxsoftware.com/GBSpreadsheetFree.htm[^]

It's got a free version with some limitations(<=150 rows per sheet && <= 5 sheets per file). Maybe you'll find it useful.

Re: Reading Excel Sheets in C#

meeram3957-May-07 0:40

meeram395

7-May-07 0:40

Hi,

Thank you for your efforts and timings. I can use this component in one of my other application.

But, in this application, the no.of rows may exceed 150. It will be upto 15000 max and also the sheets are likely to increase by one or two. So how should I handle in such a case? Is there anyway like Sheets.Find and giving the worksheet name?

Thanks for all your help.

Meeram395

Re: Reading Excel Sheets in C#

Sk8tz7-May-07 1:01

Sk8tz

7-May-07 1:01

If I was you..

Use ODBC via ADO.. then its just like accessing a .net dataset.

Sk8tZ

Installing and unistalling client certificates to personal store

blackjack21506-May-07 22:29

blackjack2150

6-May-07 22:29

Hi.

I'm developing a client for a web service which requires SSL authentication(via https).

Normally certificates are installed manually by the the user. But I am assuming that many different users with many different certificates will use the same computer and I don't want to have all the certificates installed at a given time for security reasons.

What I want to do is to implement a mechanism so that the certificate used for authentication can be installed before the web method call and uninstalled afterwards. So I've written a couple methods to do this.

The problem is that the InstallCert method does not install the certificate, but the UninstallCert methods does what's supposed to do, assuming that the certificate in subject has previously been installed in the store(for now I do that manually).

Any clues?
Thanks a lot.

Relevant code below.

X509Store store_Personal = new X509Store(StoreLocation.CurrentUser);<br />
<br />
private void InstallCert(X509Certificate2 theCert)<br />
        {<br />
            store_Personal.Open(OpenFlags.ReadWrite);<br />
            store_Personal.Add(theCert);<br />
            store_Personal.Close();<br />
        }<br />
<br />
        private void UnistallCert(X509Certificate2 theCert)<br />
        {<br />
            store_Personal.Open(OpenFlags.ReadWrite);<br />
            store_Personal.Remove(theCert);<br />
            store_Personal.Close();<br />
        }

Re: Installing and unistalling client certificates to personal store

blackjack21507-May-07 0:11

blackjack2150

7-May-07 0:11

Low activity on Monday it seems... Smile | :)

I found a way to make it work but I still don't understand why it didn't work in the first place. D'Oh! | :doh:

It's totally unlikely to be a bug, but it seems that way.

So, instead of adding the single certificate to the certificate store, I add a collection of certificates(which only holds one certificate) using the AddRange() method of the X509Store object. And it works.

If you are really really bored and have nothing else better to do you might as well try it. It's just a few lines of code.

Have a nice day!

using tree view node to select tabds

rkherath6-May-07 22:17

rkherath

6-May-07 22:17

hi All,

I am having an application which i wanna select tabs when user clicks on the relevant node.

eg:

Tree View: Tab Page

Main(root)
...Tab1(child)_____tabPage1(Get Slected)
...Tab2(child)_____tabPage2(Get Slected)
...Tab3(child)_____tabPage3(Get Slected)

some thing like that.

I got no idea how o do.
Please help me.

Regards
Ruwandi

rkherath

Re: using tree view node to select tabds

Ch_Shahzad iqbal7-May-07 1:02

Ch_Shahzad iqbal

7-May-07 1:02

Dear Used Thsi Event of Tree View Control
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
textBox1.Text = e.Node.Text;
}

How to bind multiple tables to a binding navigator

Phoenix1016-May-07 21:46

Phoenix101

6-May-07 21:46

Hey, I was wondering if there is anyway of binding data from multiple
tables to ONE Binding Navigator. Or if i can bind the results of a query to it?
Sigh | :sigh:

Phoenix

Re: How to bind multiple tables to a binding navigator

rkherath6-May-07 22:21

rkherath

6-May-07 22:21

i think you can create a quiry-->fill it to a dataset and bind the data set to the control

im not much clear of what you require. but hope this will help

Regards
Ruwandi

rkherath

Re: How to bind multiple tables to a binding navigator

Phoenix1016-May-07 22:32

Phoenix101

6-May-07 22:32

I'm displaying the results from the query in labels, but i need to loop thru it using a navigator Cry | :((

. I'll give your suggestion a go and tell you what happens.

Thanx for the reply Big Grin | :-D

Phoenix

How to bind multiple tables to a binding navigator

Phoenix1017-May-07 6:29

Phoenix101

7-May-07 6:29

Hey thanxs for the help. I managed to fill the dataset with the results from the query but dont know how to bind the dataset to the Binding Navigator Sigh | :sigh:

. Please can you help me Confused | :confused:

Phoenix

Re: How to bind multiple tables to a binding navigator

Ch_Shahzad iqbal7-May-07 1:33

Ch_Shahzad iqbal

7-May-07 1:33

Dear Used The Stored Procedure or View For Multiple Tables Data In One RecordSet

Adding item from application to local mobile calendar

chloe_hhi6-May-07 21:46

chloe_hhi

6-May-07 21:46

I am now developing a mobile application using Mobile Client Software Factory and c#. Currently what i need to do is, I have a screen where it have a choice of events, I will have a button where it will add the event from the system to the calendar that build in with mobile application and this will be the reminder.

Can i know whether this can be done?

Thanks.

Form Closing Validation Problem

PriteshMalvan6-May-07 20:55

PriteshMalvan

6-May-07 20:55

Hello Friends
i Have 2 text box
both have validation on validated event
it work well but
when user open form & direct press close button of form
validate event fired first so , how i can prevent this validtion.
Sleepy | :zzz:

Re: Form Closing Validation Problem

Sandeep Akhare6-May-07 21:24

Sandeep Akhare

6-May-07 21:24

PriteshMalvan wrote:
both have validation on validated event

When are you firing this event ? i think you are doing on pageload ..
Fire this event on submit button click if you have

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Form Closing Validation Problem

Jaiprakash M Bankolli6-May-07 23:16

Jaiprakash M Bankolli

6-May-07 23:16

Sandeep it is not related to pageload event. What exactly is happening is that when the user clicks on the close since all the validators are on so it fires the validation. So to avoid this you need to use the causevalidation property of the control. Set to false and things are done for you.

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
My Blog
Suggestions for me

Re: Form Closing Validation Problem

Sandeep Akhare6-May-07 23:25

Sandeep Akhare

6-May-07 23:25

i thought that he has written some javascript validation in some event
i never made CausesValidation to true that might be reason
Any way Thanks for showing right path

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

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