C# Discussion Boards - CodeProject

Re: Arraylist problem!!!

Amit Patel198522-Sep-09 0:23

Amit Patel1985

22-Sep-09 0:23

can u tell what was the problem u were facing??

Thanks,

Amit Patel

Export and save dataset to excel

kdwarak21-Sep-09 18:41

kdwarak

21-Sep-09 18:41

Hi,

I am able to export dataset into excel using stringwriter and response method using c#.
but i want to save the excel file in a folder without opening the file.
could anyone help out please.

Thanks

Re: Export and save dataset to excel

Programm3r21-Sep-09 21:24

Programm3r

21-Sep-09 21:24

Hi,

See...

Export dataset into excel file[^]

Export a DataSet to Microsoft Excel without the use of COM objects[^]

Export DataSet to Excel in C#[^]

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Export and save dataset to excel

kdwarak22-Sep-09 2:16

kdwarak

22-Sep-09 2:16

Hey Programmr and amit thanks a lot for giving those url.it was very useful.

Re: Export and save dataset to excel

Programm3r22-Sep-09 2:26

Programm3r

22-Sep-09 2:26

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Export and save dataset to excel

Amit Patel198522-Sep-09 0:35

Amit Patel1985

22-Sep-09 0:35

hi,

Use following link

Thanks and regards,

Amit Patel

Is it possible to reconnect an event without raising it?

CBenac21-Sep-09 14:19

CBenac

21-Sep-09 14:19

I have a C# Silverlight 3 app composed of 2 calendar controls. Both have their own SelectedDateChanged event hooked up in the constructor of the class. When user changes the date in one of the controls, the SelectedDateChanged event is raised and some code is executed, mainly to update the SelectedDate property of the other control, but this will also raise the event in the other control as well. I don't want this to happen so, inside the code, before updating the SelectedDate property I disconnect the event in the other control, preventing it to be raised. The problem is that, at the end, when the event is reconnected, it fires, making this logic useless. Is there anyway to do the reconnection without firing the event?

public partial class Page1: UserControl

// Hook events in the Constructor
public Page1()
         {
            calendarCheckInDate.SelectedDateChanged +=new EventHandler<SelectionChangedEventArgs>calendarCheckInDate_SelectedDateChanged) ;

            calendarCheckOutDate.SelectedDateChanged +=new EventHandler<SelectionChangedEventArgs>(calendarCheckOutDate_SelectedDateChanged);

         }

         // Call event in normal operation
private void calCheckInDate_SelectedDateChanged(object sender,SelectionChangedEventArgs e)
            {

                        // disconnect event on other control
calendarCheckOutDate.SelectedDateChanged -= calendarCheckOutDate_SelectedDateChanged;
                        try
                        {
                           // run some business logic code
                        .....
                        .....
                        calCheckOutDate.SelectedDate.Value =   someothervalue;

                        }
                        catch (Exception ex)
                        {
                              MessageBox.Show(ex.Message);
                        }
                        finally
                        {

                        // Reconnect the event in the other control.
                        // NOTE: THE EVENT WILL BE RAISED HERE
calendarCheckOutDate.SelectedDateChanged += calendarCheckOutDate_SelectedDateChanged;
                        }
                  }
            }

Re: Is it possible to reconnect an event without raising it?

Gideon Engelberth21-Sep-09 16:54

Gideon Engelberth

21-Sep-09 16:54

I can't say why the event is being raised; from what you have shown it shouldn't be raised. However, an alternate way to handle the problem would be to not remove the handlers at all. Instead you could use a guard flag to determine if you are changing the value from inside the other handler.

private bool inHandler;
private void calCheckInDate_SelectedDateChanged(...)
{
  if (inHandler) return;

  try
  {
    inHandler = true;
    //other logic here
  }
  finally
  {
    inHandler = false;
  }
}

Re: Is it possible to reconnect an event without raising it?

CBenac22-Sep-09 9:30

CBenac

22-Sep-09 9:30

I've applied your sugestion and it works. However, since the "finally" clause executes before the event in the other control is raised, I moved the "inHandler = false" inside the other control.
I really would have preferred to disconect the event but your idea does the work as well.

Thanks!

Cid

How to start a NamedPipeClientStream and a NamedPipeServerStream together

AndyASPVB21-Sep-09 14:19

AndyASPVB

21-Sep-09 14:19

Hi
I have constructed two straightforward named pipes, but problem is how to start them off together in their own threads in order to commence the transfer of messages.

Do some research, I have noticed that some of my solution may be found in delegates using begin invoke, invoke and end invoke. Unfortunately, I need some help as I am little new to this.

So, could someone please advise me how it would be possible to give a named pipe client stream and a named pipe server stream their own thread and to start them off together in their own thread with using delegates?

Thanks

Re: How to start a NamedPipeClientStream and a NamedPipeServerStream together

Michael Eber22-Sep-09 20:15

Michael Eber

22-Sep-09 20:15

Just a suggestion....

make each end a wcf endpoint
set the attributes to use NamedPipes
pass the data over the wcf pipline

Silverlight replace elements app

User 602357121-Sep-09 12:14

User 6023571

21-Sep-09 12:14

Hi everyone, i wanted to know if someone here knows where could i find some tutorials to accomplish the following:

I want to make a silverlight app that shows in a main screen a pictures of a room, let´s say a living room, and i want to have a small menu at the left with a scroll bar with different things in it(different lamps, flowers, candels, etc.) and what i want to do is to drag and drop the desired element and place it into the main picture (living room).

Im pretty much a newbie so any tutorial that you can point at will be really usefull.

Thanks in advanced.

modified 6-Apr-22 21:01pm.

Re: Silverlight replace elements app

Henry Minute21-Sep-09 12:35

Henry Minute

21-Sep-09 12:35

Whilst you may get an answer from somebody here, you would be better to post this in the Silverlight Forum.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Problem with delegate for C++ DLL callback function

Matthew Page21-Sep-09 12:10

Matthew Page

21-Sep-09 12:10

First, let me say that I am not a C# programmer. Complete newb here... Don't hate me because I'm beautiful...

I am trying to create a drop-dead simple application that will set a function callback address in the C++ COM dll to point to a C# function in the demo application. (This is for a sample application to demonstrate our API to potential users.) I have it working for both C++ and Visual Basic, but thus far, C# success is eluding me.

Here is what I have done...
Created a simple form with three text boxes that will be filled with XYZ values when everything works.
Within the namespace of my app (TestCSharpApp... so I lack imagination... sue me...) I have created a delegate function like this.

public delegate void coordCallbackFunction(double x, double y, double z, int buttonNumber );

In my public partial class Form1 : Form class, I have the function I want to call.

public void coordHandler(double x, double y, double z, int buttonNumber)
{
   xCoord.Text = x.ToString();
   yCoord.Text = y.ToString();
   zCoord.Text = z.ToString();
}

Finally, In the form load function I have this code.

MyCOMInterfaceLib.MyCOMClassClass myApi = new MyCOMInterfaceLib.MyCOMClassClass();
myApi.coordCallback += new coordCallbackFunction(this.coordHandler);

I realize that myApi will go away right after setting up the callback, but I am just trying to get it to compile. I'll worry about details later.

When I compile the program I get this error...

Error 1 Cannot implicitly convert type 'TestCSharpApp.coordCallbackFunction' to 'MyCOMInterfaceLib._IMyCOMClassEvents_coordCallbackEventHandler' C:\Temp\TestCSharpApp\Form1.cs 38

I have included the MyComInterfaceLib in my list of references. I can call functions from the COM dll and that works fine. The problem is setting the callback function using delegates.

It may not mean much, but the callback functions work fine in VB.Net, so I don't think the problem is in the COM dll.

Thank you for any help.

Re: Problem with delegate for C++ DLL callback function

Matthew Page21-Sep-09 12:54

Matthew Page

21-Sep-09 12:54

I really don't like answering my own questions...

Apparently C#, unlike VB, automatically creates delegates for COM events. So instead of creating my own function I use theirs.

Code then becomes,

myApi = new MyCOMInterfaceLib.MyCOMClassClass();
myApi.coordCallback += new _IMyCOMClassEvents_coordCallbackEventHandler(this.coordHandler);

If there is a better or easier way to do this, please let me know.

Otherwise, thank you.

- Matt

Adding custom properties to a DataGridViewRow

theallmightycpd21-Sep-09 10:33

theallmightycpd

21-Sep-09 10:33

I have a DataGridView. I am in need of adding additional properties to each row. I would assume this would consist of extending the DataGridViewRow class.

If my assumption is correct, how would I implement this class so that when adding rows to the datagridview, each row is created as a ExtendedDataGridViewRow rather than a DataGridViewRow.

If I am completely heading in the wrong direction, what would be a better way of accomplishing my goal?

Thanks in advance!

Re: Adding custom properties to a DataGridViewRow

Henry Minute21-Sep-09 12:41

Henry Minute

21-Sep-09 12:41

theallmightycpd wrote:
I have a DataGridView. I am in need of adding additional properties to each row.

You seem to have already decided how to proceed.

theallmightycpd wrote:
If I am completely heading in the wrong direction, what would be a better way of accomplishing my goal?

Or maybe not. Smile | :)

Seriously, it will be very difficult for anyone to advise you accurately because you have not described what it is you are trying to do. Forget about the 'extending DataGridViewRow' stuff and describe the problem that made you decide that that is the way to go in the first place.

Re: Adding custom properties to a DataGridViewRow

theallmightycpd22-Sep-09 4:39

theallmightycpd

22-Sep-09 4:39

First of all, I want to add a filter to the datagridview. I have completed this step by adding dropdowns to the column headers that populate with that columns values (uniquely). When a row does not match the current filter, its visibility is set to false.

Next, I want to add the ability to expand and collapse similar rows. For instance, if Row A contains the values {Test,1,2,3} and row B contains that values {Test,A,B,C}, the row can be collapsed into a header row with just the value {+,Test}. The plus symbol would be used to expand back into the two rows. A - on the header row will collapse back in to just the single row. When rows are collapsed, I am setting their visibility to false, also.

Currently, these features work separately, but do not work together. When a row's visibility is false, I don't know if it's because it doesn't match the filter or if the row is collapsed. What I would like to do is to add additional properties to each row describing when it is a row included or excluded in the current filter and another property for the expand/collapse header rows describing how many rows are assosicated with that header.

I hope this makes my intentions clearer.

Re: Adding custom properties to a DataGridViewRow

Henry Minute22-Sep-09 5:08

Henry Minute

22-Sep-09 5:08

What you are trying to do sounds a little like a cross between a TreeGridview[^] and OutlookGrid: grouping and arranging items in Outlook style[^].

I hope that the links above will at least give you some ideas, if you haven't seen them before. Smile | :)

Using StringBuilder inside another class?

helfri6221-Sep-09 10:27

helfri62

21-Sep-09 10:27

I'm working on my first C# project, first real programming in a while. Not exactly like riding a bike...

I'm trying to create a class or struct that contains a StringBuilder. Truthfully, either class or struct, either string or StringBuilder should work OK, but a class with StringBuilder seems like the *right* solution. But I get errors.

Here is the class:

public class sheetCols
{
string colHdg;
public string colLetter;
public StringBuilder colValue = new StringBuilder(" ");
                  

    public sheetCols(string s1, string s2, string s3)   //error indicated on "sheetCols"
    {
         this.colHdg = s1;
         this.colLetter = s2;
         this.colValue.Length = 0; // warning indicated on this.colValue
         this.colValue.Append(s3);
    }
}

The error I see on the constructor is:
Field 'RAContractToolConsole.Program.sheetCols.colValue' must be fully assigned before control is returned to the caller

The warning on the Length assignment is:
Use of possibly unassigned field 'colValue'. Struct instance variables are initially unassigned if struct is unassigned.

I looked around on CodeProject and elsewhere online; can't find an answer.   One post alluded to a bug in VS, but that was v7, and I'm on VS2008 (aka v9), updated according to Windows Update.

What am I missing?   Is it possible to use a StringBuilder inside another class?   I couldn't find an example online.

Thanks in advance.

Re: Using StringBuilder inside another class?

Luc Pattyn21-Sep-09 10:40

Luc Pattyn

21-Sep-09 10:40

Hi,

when sheetCols is a class (as in your snippet), the code is fine.

when sheetCols is a struct, it would not be OK:
- you can't have initializers on struct members;
- every consrtuctor needs to initialize all data members.

Here are some suggestions for you:
- tell your IDE to always show line numbers in editor windows (see here[^]);
- watch the squiggly lines (red or green) Visual Studio uses to flag problems;
- watch the errors and warnings any IDE will produce; and focus on the first one first; you must get rid of all errors before you can execute, and it is wise to also get rid of the warnings.
- be meticulous; every single keyword and punctuation mark matters.

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: Using StringBuilder inside another class?

helfri6221-Sep-09 11:00

helfri62

21-Sep-09 11:00

Thanks, Luc.   I changed my settings like you suggested.   Good ideas.

Now I'm really scratching my head.   Did nothing more than save the files and exit VS.   Now when I went back to look at the errors again, since you said it should work, THEY ARE GONE!   But I didn't change any code.

I don't get it.   I've seen other inconsistencies. I have a couple of objects declared and instantiated at the beginning of the program, and I get errors that they are unassigned local variables.   But if I start the build, those 2 errors disappear from the error list, and the program runs as expected.

Re: Using StringBuilder inside another class?

Luc Pattyn21-Sep-09 11:10

Luc Pattyn

21-Sep-09 11:10

Hi,

some comments on Visual Studio:
1. there are a lot of settings, so behavior may be different on different machines;
2. there is some background checking going on, so warnings/errors may come and go while you edit, without explicitly invoking a compilation;
3. the "Error List" pane lags your editing, it may still be showing the results from the latest build.
4. under menu Tools/Options/Build and Run, there is a setting "On run when there are errors..." I strongly recommend "do not run" as opposed to "run older version" as this is really confusing.

Hope this helps.

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Local announcement (Antwerp region): Lange Wapper? Neen!

Thread reach synchronized code block

FJJCENTU21-Sep-09 7:33

FJJCENTU

21-Sep-09 7:33

What happens if a thread call a method and find a blocked code area inside this method (with lock, Monitor ...) if follow with the rest of the method don´t blocked or stay waiting in the initious of the blocked area until the thread inside the block release it ?

Regards

Re: Thread reach synchronized code block

N a v a n e e t h21-Sep-09 8:01

N a v a n e e t h

21-Sep-09 8:01

It waits until the lock releases.

Navaneeth

How to use google | Ask smart questions

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