C# Discussion Boards - CodeProject

Christian Graus21-Jul-09 10:19

21-Jul-09 10:19

1 - what do you mean by query wizard ? To talk to a DB ? You connect, you take input, and you run it on the DB.
2 - Then you add a column and put the values in there

mohammad alnoed wrote:
note
i am using c sharp .net

Well, in this forum, of course you are.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Q in query wizard

mohammad alnoed21-Jul-09 21:51

mohammad alnoed

21-Jul-09 21:51

yes I was creating connection to access database using wizard connection

but i do not know how i can create query by wizard
after that i need to add the result to colume in datagridview
datagridview1.Rows[1].cell[2].vlaues="i want add the query wizard here";
thanks

[Solved] Clearing control of graphics before painting [modified]

Jordanwb21-Jul-09 4:58

Jordanwb

21-Jul-09 4:58

I have a class called CardHolder which extends UserControl. I have overrode its OnPaint function like so:

protected override void OnPaint(PaintEventArgs e)<br />
{<br />
    base.OnPaint(e);<br />
<br />
    Graphics g = e.Graphics;<br />
<br />
    foreach (Card c in this.Controls)<br />
    {<br />
        g.DrawImage(c.Image, c.Location);<br />
    }<br />
}

Each image is tied to a Control which has been added to this control. Each image is a partially transparent image which is partially overlaid another image. However, each time the OnPaint function is called, it doesn't clear the Control of what was there before:

Good: http://img20.imageshack.us/i/goodw.jpg/[^]

Oh dear: http://img24.imageshack.us/i/ohdearz.jpg/[^]

I've hooked into the CardHolder's Resize event and call PositionCards in that function to position the Controls, which in turn calls OnPaint behind the scenes. I hope what I'm doing here makes sense to you guys. How do I clear the Control of the previously drawn images?

Card extends UserControl as well but is transparent and has no child controls.

modified on Tuesday, July 21, 2009 12:36 PM

Re: Clearing control of graphics before painting

Nagy Vilmos21-Jul-09 5:22

Nagy Vilmos

21-Jul-09 5:22

How is the OnPaint being called? Call the Refresh() method to make your control invalidate the graphic and repaint itself.

Panic, Chaos, Destruction.
My work here is done.

Re: Clearing control of graphics before painting [modified]

Jordanwb21-Jul-09 5:38

Jordanwb

21-Jul-09 5:38

I don't know how OnPaint is being called. I'll give Refresh a try.

[Edit]

Thanks Nagy Vilmos.

modified on Tuesday, July 21, 2009 12:35 PM

How to Pass Crystal Reports Parameter

Ahmed Khallaf21-Jul-09 4:21

Ahmed Khallaf

21-Jul-09 4:21

i want to filter report made by Crystal Reports
and i made it by the wizard
and here is an example so i want to pass the value of the field of Employee Name For example from a textbox or another contorle by the user then the report appears the records that the user want to display
and many thanks for you
http://ahmedkhallaf.brinkster.net/WindowsFormsApplication1.rar[^]

Allah bless the prophet Mohammed

Re: How to Pass Crystal Reports Parameter

Nagy Vilmos21-Jul-09 5:18

Nagy Vilmos

21-Jul-09 5:18

0. No-one will download your code and fix it for you.
1. I am not a fan of CrappyReports; they have to grind down cute puppies to build this software.
2. I am guessing you have a paramatised report and a form for entering said paramater. Check the CR documentation [har har] on how to pass on to the other.
3. There are 865,492 better reporting tools that are free!

Panic, Chaos, Destruction.
My work here is done.

Re: How to Pass Crystal Reports Parameter

Ahmed Khallaf21-Jul-09 5:37

Ahmed Khallaf

21-Jul-09 5:37

thank you for you kind reply and i have fixed my problem

Allah bless the prophet Mohammed

Inheritance

loupceuxl21-Jul-09 4:11

loupceuxl

21-Jul-09 4:11

Hi from what I understand, the built-in System.Windows.Forms.Label class inherits from the System.Windows.Forms.Control class. Is there any way to change the Form.Label class' inheritance to a custom (SectionControl) class which is derived from the Forms.Control class?

so basically,

class SectionControl : Control
class MyLabel : Label

but override/replace the existing implict 'System.Windows.Forms.Label : Control' inheritance to 'System.Windows.Forms.Label : SectionControl'.

That way I get the benefits from both the SectionControl and MyLabel specializations. If this is possible I would proceed to add MyTextBox, MyCheckBox, etc... classes also deriving from the obvious parent and thereby retaining the commonality of all the custom controls in the SectionControl class. As C# doesn't allow multiple inheritance, and as i'm not interested in a semantic Interface either I'm at a loss. Any suggestions?

Re: Inheritance

PIEBALDconsult21-Jul-09 4:16

PIEBALDconsult

21-Jul-09 4:16

No. But you could wrap a Label in something that derives from SectionControl.

Calculation of Efficiency using Microsoft Solver Foundation

Anuj Chauhan from India21-Jul-09 3:47

Anuj Chauhan from India

21-Jul-09 3:47

Hi All,

Is it possible to calculate Efficiency of different Business Units on the basis some inputs and output using Microsoft Solver Foundation?

Following is the sample data for which efficiency needs to calculate.
Each row here represent the details of each Business Units.
1st column "Location" contains the location of business unit
2nd & 3rd columns "Personal" & "Business" are the outputs
4th column "Staff" is the input.

Location Personal Business Staff
Croydon 125 50 18
Dorking 44 20 16
Redhill 80 55 17
Reigate 23 12 11

In MS Excel, there is a add-in named as "Solver" that can be used to calculate the efficiency. For that we need to add the weighted output, weighted input and some more columns to meet the requirement of Solver add-in.

I believe some thing similar should be existing with Microsoft Solver Foundation, and can be calculate the efficiency programatically.

you all are requested to provide your thoughts on the same...

An earlier reply will be appreciated.

Regards,
Anuj Chauhan
anuj.mca@gmail.com
+91 9313499294
http://www.linkedin.com/in/anujchauhan[^]

Get file path hosted by an Excel process

Muneeb Abdul Shakoor21-Jul-09 3:38

Muneeb Abdul Shakoor

21-Jul-09 3:38

Hi!
I want to get the file path hosted by a certain excel process. I have its Process object only.
Thanks in advance.

Re: Get file path hosted by an Excel process

Brij21-Jul-09 3:45

Brij

21-Jul-09 3:45

Check the Link

Hope it helps

Cheers!!
Brij

Re: Get file path hosted by an Excel process

Muneeb Abdul Shakoor21-Jul-09 3:57

Muneeb Abdul Shakoor

21-Jul-09 3:57

Thanks for your reply. But that code brings focus forcefully to the excel application which I dont want and Marshal.GetActiveObject() will not work in that case.

System.Timers.Timer doesn't stop with Stop()

SimpleData21-Jul-09 2:24

SimpleData

21-Jul-09 2:24

Hi I have a timer which I've created in runtime with System.Timers.Timer myTimer = new System.Timers.Timer(10000);

I make some settings of this timer and start it with this code:

myTimer.Elapsed += new ElapsedEventHandler(myMethod);
myTimer.Start();

After myTimer started I stop myTimer using myTimer.Stop();

Some time later I need to start myTimer again so I start it with myTimer.Start(); But the weird thing is that it didn't actually stop when myTimer.Stop(); was executed. It's like two instances of myTimer are ticking at different times but I just want the last one to work.

How can I solve this problem?

Thanks in advance.

Re: System.Timers.Timer doesn't stop with Stop()

Abhishek Sur21-Jul-09 2:55

Abhishek Sur

21-Jul-09 2:55

I think the code block where new ElapsedEventHandler is added is called more than once.

It means when even is raised, more than once the myMethod will be called, and hence the timer will be incremented.

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: System.Timers.Timer doesn't stop with Stop()

SimpleData21-Jul-09 2:58

SimpleData

21-Jul-09 2:58

So can I add more than one ElapsedEventHandler to my timer right?

If I

myTimer.Elapsed += new ElapsedEventHandler(Method1);
myTimer.Elapsed += new ElapsedEventHandler(Method2);

then when myTimer ticks both Method1 and Method2 runs, right?

If I

myTimer.Elapsed += new ElapsedEventHandler(Method);
myTimer.Elapsed += new ElapsedEventHandler(Method);

then when myTimer ticks Method will run twice, right?

Re: System.Timers.Timer doesn't stop with Stop()

stancrm21-Jul-09 3:18

stancrm

21-Jul-09 3:18

right

Re: System.Timers.Timer doesn't stop with Stop()

DoctorMick21-Jul-09 3:18

DoctorMick

21-Jul-09 3:18

Right, right and right again.

Re: System.Timers.Timer doesn't stop with Stop()

SimpleData21-Jul-09 3:19

SimpleData

21-Jul-09 3:19

Thank you, then problem solved Big Grin | :-D

Re: System.Timers.Timer doesn't stop with Stop()

PIEBALDconsult21-Jul-09 4:13

PIEBALDconsult

21-Jul-09 4:13

Yes, but I doubt you want to do that; did you do that accidently?

Re: System.Timers.Timer doesn't stop with Stop()

SimpleData21-Jul-09 4:14

SimpleData

21-Jul-09 4:14

Yes.

Re: System.Timers.Timer doesn't stop with Stop()

Abhishek Sur21-Jul-09 21:37

Abhishek Sur

21-Jul-09 21:37

So on every block I think it is better to do

myTimer.Elapsed -= new ElapsedEventHandler(Method);
myTimer.Elapsed += new ElapsedEventHandler(Method);

By this way even if this block is running more than one, everytime it will remove the eventhandler and then add it. Provided, if you are unsure that this block will run more than once.

Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: System.Timers.Timer doesn't stop with Stop()

SimpleData21-Jul-09 23:28

SimpleData

21-Jul-09 23:28

Thank you, that is a nice way of doing it too.

But I solved it with adding a global int called Session with default value 0. And everytime I get this adding ElapsedEventHandler if this session is greater than 1 I don't add it.

Re: System.Timers.Timer doesn't stop with Stop()

Abhishek Sur22-Jul-09 21:47

Abhishek Sur

22-Jul-09 21:47

yes .. this is a possible way...
nice to hear that you solved it.

Cheers. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

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