C# Discussion Boards - CodeProject

Re: Deleting multiple values from the grid view and database table using windows form in C#.

Mycroft Holmes21-Jul-09 14:57

21-Jul-09 14:57

Loop through the rows in the datagridview
identify the record that is checked
Delete it from the database
reload the DGV

Loop through the rows in the datagridview in REVERSE
identify the record that is checked
Delete it from the database
Delete the row from table/list supporting the DGV

Never underestimate the power of human stupidity
RAH

how use the clear

neha_rai21-Jul-09 10:31

neha_rai

21-Jul-09 10:31

List<points> points = new List<point>();

i need to know how can i empty the list class(i.e. clear all the points i have created on the form) at button click event...please help !

Re: how use the clear

Blue_Boy21-Jul-09 10:42

Blue_Boy

21-Jul-09 10:42

What concretely is List? Is your own class? Which items you want to clear?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: how use the clear

neha_rai21-Jul-09 10:49

neha_rai

21-Jul-09 10:49

the one that exists already not my own.

protected override void OnPaint(PaintEventArgs e)
{
foreach (Point dot in dots)
{
// code to create marks in form of small circles using e.graphics
}
base.OnPaint(e);
}

i wish to delete those circles now..!!

Re: how use the clear

0x3c021-Jul-09 11:01

0x3c0

21-Jul-09 11:01

Then you call dots.Clear();. For what it's worth, you can find this information by searching MSDN

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Re: how use the clear

neha_rai21-Jul-09 11:49

neha_rai

21-Jul-09 11:49

it had not worked...i have used e.graphics.DrawEllipse to get my small dots n the appear on mouse clicks..

Re: how use the clear

Christian Graus21-Jul-09 11:01

Christian Graus

21-Jul-09 11:01

Wow. You even said it. dots.Clear();

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: 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[^]

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