Re: Q in query wizard - C# Discussion Boards

Re: how use the clear

neha_rai21-Jul-09 11:46

neha_rai

21-Jul-09 11:46

ya i had tried that but its not working..any clue why..??

Re: how use the clear

Christian Graus21-Jul-09 13:01

Christian Graus

21-Jul-09 13:01

OK, well, perhaps you need to ask the right question. The clear method DOES work, obviously. So, there's something wrong with your code. We'd need to see the code to be able to suggest what it is.

One guess, do you call Invalidate() after you clear the list, and if not, what were you expecting to cause a paint event ?

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.

How to get the selected ToolStripeItem

neus8321-Jul-09 7:48

neus83

21-Jul-09 7:48

Hi all,

I was creating a ToolStripe with a few Buttons.

I was creating a SplitButton. This Button has Items.

i.e:
Start Program 1
Start Program 2
Start Program 3

How can I get the select Text of the items ?
My sample returns only the name of the split button Frown | :(

MessageBox.Show("ITEM: " + item.Name + " " + ButtonBenutzerAuswahl.Selected.ToString());

Re: How to get the selected ToolStripeItem

DaveyM6921-Jul-09 9:43

DaveyM69

21-Jul-09 9:43

Have you tried the item's Text property?

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)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: How to get the selected ToolStripeItem

neus8321-Jul-09 21:45

neus83

21-Jul-09 21:45

no the item.text will not return the value of the selected DropDownItems

Re: How to get the selected ToolStripeItem

DaveyM6921-Jul-09 22:17

DaveyM69

21-Jul-09 22:17

What type of items are you adding to your split button, and what value so you expect or want to get from them?

Q in query wizard

mohammad alnoed21-Jul-09 5:59

mohammad alnoed

21-Jul-09 5:59

i have tow qutions
1-how i can create query wizard in c sharp
2-i need add the result form query to colume in datagridview control
note
i am using c sharp .net

Re: Q in query wizard

Christian Graus21-Jul-09 10:19

Christian Graus

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

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