C# Discussion Boards - CodeProject

Re: How to Refreash an array list

0x3c016-Mar-09 7:46

0x3c0

16-Mar-09 7:46

You're looking for the Array.Clear static method

Re: How to Refreash an array list

soulidentities16-Mar-09 8:01

soulidentities

16-Mar-09 8:01

thanks I got the ans

Re: How to Refreash an array list

Mohammad Dayyan16-Mar-09 9:44

Mohammad Dayyan

16-Mar-09 9:44

Was your meaning ~~refreash~~ refresh ? Confused | :confused:

Re: How to Refreash an array list

S K Y16-Mar-09 15:09

S K Y

16-Mar-09 15:09

foreach(object yourArrayItem in yourArray)
{
youArrayItem.remove();
}

A S E L A

C# and Excel

su_penguin16-Mar-09 6:42

su_penguin

16-Mar-09 6:42

Hello all,

Excel.Application excel = new Excel.Application();
Excel._Workbook book = new Excel._Workbook();
Excel._Worksheet sheet = new Excel._Worksheet();
Excel.Range range = new Excel.Range();

After adding a reference to the Excel Object Library in my VC# project, these few lines start the process of opening a 'new' workbook. But, how do you open a workbook that already exists?
I would like to point to the link to the existing book, if possible.

Thanks

Re: C# and Excel

Jimmanuel16-Mar-09 6:58

Jimmanuel

16-Mar-09 6:58

excel.Workbooks should have an Open(...) method in it.

Re: C# and Excel

su_penguin16-Mar-09 7:01

su_penguin

16-Mar-09 7:01

THANK YOU!!!

Re: C# and Excel

Jimmanuel16-Mar-09 7:44

Jimmanuel

16-Mar-09 7:44

You're welcome. Smile | :)

Re: C# and Excel

su_penguin16-Mar-09 8:15

su_penguin

16-Mar-09 8:15

This method really stinks. Why is this in the object model? http://msdn.microsoft.com/en-us/library/bb179167.aspx

Thanks

Re: C# and Excel

Jimmanuel16-Mar-09 8:49

Jimmanuel

16-Mar-09 8:49

it's there so you can open existing workbooks Smile | :)

. I'm not sure about the 2007 version, but with the Office XP version you can get away with passing in System.Reflection.Missing.Value for all the parameters except the first one - provided that you don't care what those params are.

c# class editor

MikiR16-Mar-09 6:24

MikiR

16-Mar-09 6:24

Hello,
I'm trying to create an application, using c#, that takes a .cs source file, parses it (I just need to extract class name, methods, properties, structs, enums) and then lets the user to perform some operations like add new method, delete a method or insert some line of code in an existing method.
At the moment to achieve it, I use a parser library (NRefactory from SharpDevelop) and then I thought to perform these operations using CodeDom functions.
But using CodeDom it's painful!! Is there any other library that I could use?
Is the method I described (NRefactory + CodeDom) the best way or is there something else I should try?

Thanks

Re: c# class editor

led mike16-Mar-09 6:59

led mike

16-Mar-09 6:59

MikiR wrote:
the best way

Best in comparison to what? Measuring with what criteria?

Your question, or lack of one, suggests you might be better served focusing on getting something, anything to work.

Re: c# class editor

MikiR16-Mar-09 7:10

MikiR

16-Mar-09 7:10

Ok, forget "best way" phrase. It's the worst expression I ever used and
trust me, I'll never use it in my life! I promise!!

Now..Can I have an answer about my problem? It's there an easy ("easy" in comparison to what?) way (some libray, some helper class) that help me to use CodeDom to inserting piece of code, adding/removing methods to an already parsed c# class?

Accessing a Web.config from a windows app [modified]

dptalt16-Mar-09 5:28

dptalt

16-Mar-09 5:28

How can I read a connection string in web.config file from a windows app?
The ConfigurationManager.ConnectionStrings is not available from a windows project.

modified on Monday, March 16, 2009 12:07 PM

Re: Accessing a Web.config from a windows app

led mike16-Mar-09 5:42

led mike

16-Mar-09 5:42

dptalt wrote:
How can I accesses a web.config from a windows app?

From your post it is not clear what the technical problem is, nor what your question really is.

web.config is a file. Do you not know how to open a file?

Open SQL connection via C#

Ido16-Mar-09 4:44

Ido

16-Mar-09 4:44

Hi,
I am working under C# 2008 and SQL 2005 express edition.

To connect to database I used with Typed Dataset and all insert command I used with same object. I had over million rows.

At this object I implement Insert command. I glance in “TypedDataset.Designer.cs” file under my Typed Dataset at Insert command and see that Adapter open and close the connection after each insert execution.

My questions are:

1. This is necessary to open and close the connection all the time?

2. We cannot to leave the connection open?

3. What about performance?

4. There is another way to insert large quantities of rows to database?

Thanks,
Ido

Re: Open SQL connection via C#

led mike16-Mar-09 5:39

led mike

16-Mar-09 5:39

Most modern database+platform systems use connection pooling[^] so the connection is not actually opened and closed each time.

Re: Open SQL connection via C#

Ido16-Mar-09 6:36

Ido

16-Mar-09 6:36

hi,
Thanks.
so, the behavior is normally in spite of that i see on SQL Server Profiler Audit Login Audit Logout for each execution?

Re: Open SQL connection via C#

led mike16-Mar-09 6:57

led mike

16-Mar-09 6:57

Ido wrote:
so, the behavior is normally

You mean "normal"?

Ido wrote:
in spite of that i see on SQL Server Profiler

I don't know what you are seeing. The generated code is designed to be used in pooling environments because that is very very common today. You may in fact not have one. If you don't there is a problem and you need to solve it. There may be many solutions and one or more might include modifying database server configurations.

Re: Open SQL connection via C#

Ido16-Mar-09 7:28

Ido

16-Mar-09 7:28

Yes, I mean normal.
Thanks a lot you help me to understand about my problem.
Ido

Re: Open SQL connection via C#

led mike16-Mar-09 7:51

led mike

16-Mar-09 7:51

Hope you get it worked out.

Why are your posts all in bold? It makes them difficult to read. You should stop doing that.

Re: Open SQL connection via C#

fly90416-Mar-09 7:37

fly904

16-Mar-09 7:37

Ido wrote:
There is another way to insert large quantities of rows to database?

Yes, sp_xml_preparedocument[^] and here's an example.[^]

hmmm pie

Custom properties for inherited button control

akamper16-Mar-09 3:56

akamper

16-Mar-09 3:56

Hello

I've tried a lot of things already, but haven't got/found a satisfying solution.

Problem:
I have a custom control that inherits from Button. It's properties are shown in a PropertyGrid.
This control has some additional properties (which is no problem), but
I don't want to show all the standard properties like the whole Accessibility-Category and some more.

So is it possible to tell the propertygrid or the control which properties are going to be shown and which are not?

I have found to override and set the properties to "Browsable(false)", but isn't there more elegant and cleaner way to do this?
Is it possible to exclude a whole category?

The ideal case would be that my customButton only shows the Appearance, Behaviour, Design and Layout Cetagory and my own properties, but nothing else.

Thanks a lot in advance for your help

Re: Custom properties for inherited button control

DaveyM6916-Mar-09 4:57

DaveyM69

16-Mar-09 4:57

No, unfortunately not. That's the idea behind inheritance, you add to something, not take away from it. MS do it themselves of course but they don't give us the option.

The best you can do is declare the property as new instead of override, that way you can make it readonly by only providing a getter and decorating with these attributes.

[Browsable(false),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden),
Obsolete]
public new string Text
{
    get { return base.Text; }
}

EditorBrowsable(EditorBrowsableState.Never) has no effect.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: Custom properties for inherited button control

akamper16-Mar-09 21:33

akamper

16-Mar-09 21:33

Thanks a lot

I implemented it that way then.

But then occurs another question:
- I am not able to hide the "Desgin-Category" properties like (Name) and Locked.
and i couldn't find a solution on net, just some more asking for help Smile | :)

Is it possible to hide it, because the name is simply irrelevant in my application.

Thanks

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