Re: setting label.Text by the SqlDataReader's value - C# Discussion Boards

Re: setting label.Text by the SqlDataReader's value

11-Dec-10 6:52

That's looking better.

Luc Pattyn11-Dec-10 7:02

Re: setting label.Text by the SqlDataReader's value

11-Dec-10 7:02

No comment on SELECT * ?
And what about numbered fields as in GetString(1) ?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

PIEBALDconsult11-Dec-10 16:59

Re: setting label.Text by the SqlDataReader's value

11-Dec-10 16:59

Luc Pattyn wrote:
No comment on SELECT * ?

I use that all the time.

Luc Pattyn wrote:
GetString(1) ?

Eh, yeah, I never use the Get methods, I generally just cast to the type, but whatever; it's better than it was.

Luc Pattyn11-Dec-10 17:13

Re: setting label.Text by the SqlDataReader's value

11-Dec-10 17:13

if the fields get reordered, the code breaks.
which wouldn't happen when the fields were named explicitly: SELECT fieldName1,fieldName2,fieldName3 ...

The alternative is more cumbersome: reader.GetString(reader.GetOrdinal("fieldName2"))

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

PIEBALDconsult12-Dec-10 4:21

Re: setting label.Text by the SqlDataReader's value

12-Dec-10 4:21

Luc Pattyn wrote:
if the fields get reordered

Who'd do a silly thing like that?

IDataReader fields can be accessed by name too.

Item [([(String ])]) Gets the column with the specified name. (Inherited from IDataRecord.)

This is from the WCF experiment I was playing with last spring:

dr = this.con.ExecuteReader
(
    @"
    SELECT *
    FROM JunkName
    WHERE Id=@Param0
    "
,
    ID
) ;

if ( dr.Read() )
{
    result = new Junk.Types.Record()
    {
        ID              = (System.Guid)              dr [ "ID" ]
    ,
        LastName        = (string)                   dr [ "LastName" ]
    ,
        FirstName       = (string)                   dr [ "FirstName" ]
    ,
        Gender          = (Junk.Types.Gender) (byte) dr [ "Gender" ]
    ,
        FavouriteColour = Colour.Parse ( (string)    dr [ "Colour" ] )
    ,
        Created         = (System.DateTimeOffset)    dr [ "Created" ]
    } ;
}

Luc Pattyn12-Dec-10 5:34

Re: setting label.Text by the SqlDataReader's value

12-Dec-10 5:34

PIEBALDconsult wrote:
reordered. Who'd do a silly thing like that?

Could happen by accident, after a refactoring; or maybe a convoluted backup/restore operation.

PIEBALDconsult wrote:
IDataReader fields can be accessed by name too.

Sure, that is what you and I would do. All but referring by ordinal. So I did expect your objection to it.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

PIEBALDconsult12-Dec-10 5:48

Re: setting label.Text by the SqlDataReader's value

12-Dec-10 5:48

Luc Pattyn wrote:
I did expect

I try to do the unexpected and not the expected -- much like the Spanish Inquisition... oh, but maybe you expected that.

Luc Pattyn12-Dec-10 5:55

GUI User Control does not repaint it self properly after resizing it...

12-Dec-10 5:55

PIEBALDconsult wrote:
maybe you expected

you'll never now. Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Shultz 210-Dec-10 22:13

Re: GUI User Control does not repaint it self properly after resizing it...

10-Dec-10 22:13

Hi
I am working on Windows 7 x64, VS2008, FW 3.5, C# only.

I have developed a pretty complex GUI User Control, involving many UserControls planting inside table layout with in table layout with in tab layout control etc.

When starting my form, holding my complex User Control, in maximize mode all looks fine.
When starting to shrink it and then resize it (dragging the mouse from bottom right corner...) the 'deep' user controls and their components starts to be twisted and do not repaint properly.
Some of them are left half painted, showing leftovers of earlier refreshment actions happen on their pixels...

I have tried to test it and initiate (using a button) a refresh, invalidate and perform layout actions on my top UserControl, as well as on my deep one(s), but nothing helps.
I have these 'deep' user control(s) planted in other places in my GUI (less complex one I admit) and they all work properly on resize over there.

My questions:
1. Does any one have any explanation why this is going on?
2. Is there a guide line when designing a GUI in C# (or in .NET at all..) that says not to exaggerate in nesting up controls within layouts? Is there a particular overhead for this increased nesting?
3. Are there any other refresh/repaint methods that I might initiate that can fix the situation?

Thanks a'head
The Shultz.

Luc Pattyn10-Dec-10 23:41

Re: GUI User Control does not repaint it self properly after resizing it...

10-Dec-10 23:41

Hi,

I don't have any references for this, however my advice would be:

1. keep GUI's simple; don't use dozens of Controls on a single Form, as it will have a negative impact on performance (not on correct painting though), and is likely to confuse the user; either use fewer but more appropriate Controls, or consider using more than one Form.

2. from what you described: make sure custom Paint handlers also call their base.OnPaint().

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Shultz 211-Dec-10 0:18

Re: GUI User Control does not repaint it self properly after resizing it...

11-Dec-10 0:18

Hi 1. I tend to agree, but:
A. some time GUI needs to present the user multiple options and things to define.
If the user must set these things, the GUI tends to be more 'complex' then 'simple' and you cannot run from it.
Off course there are techniques how to reduce the overhead for user (use tab control, table layout etc...) but you cannot always avoid it.
This is my case and I can't actually make it 'simpler' in the aspect of less controls and components with in
B. I personally don't like, as a user, to deal with GUI that pops up forms in which things have to be defined. I tend to like much more a fixed GUI that all screens are with in, and navigation between them is done using tab control, split container etc. that is my design here as well.

2. I am not using any custom paint, so there is no reason for the controls not to redraw them selves by the system.
Note that my User Controls are used else where in my system and they function well, so I can't believe it's a structural problem with a refresh method call that is not being called when it should...

Thanks any way

The Shultz.

Keith Barrow11-Dec-10 2:27

Keith Barrow

11-Dec-10 2:27

I'm not really a Winforms bod, but do *vaguely* remember that the first thing that MS suggests with rendering problems is to ensure your Graphics drivers are up to date (naturally the problem can't be Microsoft's Rendering Mechanism Smile | :)

). I'd just check this before going on a wild goose chase.

Oh, I really do mean vaguely remember by the way.

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-A Dead ringer for Kate Winslett[^]

Re: GUI User Control does not repaint it self properly after resizing it...

Shultz 211-Dec-10 4:59

Re: GUI User Control does not repaint it self properly after resizing it...

11-Dec-10 4:59

Hi
Since my 'failed-to-repaint' User Controls are palced in other locations in my GUI, and works properly there, I can't seem to believe that this is indeed a wrong/old/bad/corrupted graphics issue, but still worth the checking...
so:

- How can I verify the 'up-to-date' of my graphics drivers ?
- Why/How could it be that they will become not 'up-to-date' ?

Dr.Walt Fair, PE11-Dec-10 5:29

Dr.Walt Fair, PE

11-Dec-10 5:29

What parts of your controls are not getting repainted? Text? Parts that are in certain containers? Does selecting the control or selecting another force a repaint?

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Re: GUI User Control does not repaint it self properly after resizing it...

Shultz 211-Dec-10 11:14

Saving a word document(2000 to 2010) to xml

11-Dec-10 11:14

For example:
- I have a list view with 10 columns and horizontal and vertical scroll bar.
When the user control gets resized, not all the columns header can be seen properly and some of their text gets mixed.
The scroll bars disappear (while they shouldn't).
When I reload items to the list it gets repainted well from the beginning.

- I have some labels with in cells in table layout. When it shrinks the label automatically wraps its text with in and changes its size over the screen, when its gets spread again, some of the labels is text remain shady and gets mixed up with neighborhood labels.

It seems like the repaint operation simply does not come to its end, so the screen is left with former pixels status - pixels that should have been repainted had the operation would have completed. How can it be?

just selecting the control and gain him a focus does not couze it to be repainted. (it should have done so ?)

I m kind'a new here, is there a way that I can upload some small printscreens to farther demonstrate what I am experiance ?

Haim Nachum10-Dec-10 6:13

Haim Nachum

10-Dec-10 6:13

Hi.
How can i save a word document to xml format for parsing later with xslt.

I noticed that word 2007-2010 document are constructed with the openxml format so i can use openxml tools to save it.
But word 2000-2003 seems to be in binary format.

Is there a tool that i can use for this mission?

Thanks

Re: Saving a word document(2000 to 2010) to xml

Not Active10-Dec-10 10:26

Not Active

10-Dec-10 10:26

Haim Nachum wrote:
Is there a tool that i can use for this mission?

Yes, Word and Save As

I know the language. I've read a book. - _Madmatt

Re: Saving a word document(2000 to 2010) to xml

Yvan Rodrigues12-Dec-10 14:18

Yvan Rodrigues

12-Dec-10 14:18

Do you (a) need to access the spreadsheet data programatically, or (b) do you just need a conversion tool.

If (a), there are one or more articles on this site that will discuss the pre-XML Word format and how to read and manipulate the data.

If (b), what level of automation do you require? Indeed, File | Save as in a recent version will let you save in either OOXML or ODF formats.

Re: Saving a word document(2000 to 2010) to xml

Haim Nachum12-Dec-10 22:57

Haim Nachum

12-Dec-10 22:57

Im sorry , i thought that if i posted the question on a c# forum and would be clear that i meant it programatically.

I will seek articals about it.

Thanks

Switch with multiple variables

jadughar10-Dec-10 4:24

jadughar

10-Dec-10 4:24

Hi
don't know if this is the right place where to post.
But i was wondering if is possible to use switch statement with multiple variables, something as below :

int x = 0;
int y = 1;

switch(x,y)
{
case 1,0 :
 Console.WriteLine("1,0");
 break;
case 0,1 :
 Console.WriteLine("0,1");
 break;
case 1,1 :
 Console.WriteLine("1,1");
 break:
default :
 Console.WriteLine("0,0");
}

thanks bye

"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras

Luc Pattyn10-Dec-10 4:29

10-Dec-10 4:29

No.
Did you check the documentation? the language specification?

You could make a composite function, in your example int z=2*x+y would suffice; but readability would suffer.

And you could make a new type, hide the values in there, spend a lot of code and waste numerous CPU cycles. What is it good for?

The obvious approach is a series of if ... else if

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

jadughar10-Dec-10 5:01

jadughar

10-Dec-10 5:01

Thaks for the reply..

The obvious approach is a series of if ... else if
i agree!

You could make a composite function, in your example int z=2*x+y would suffice; but readability would suffer.<code><br />
<br />
i used int type variables just for example, actually i'm working with strings.<br />
<br />
<br />
<br />
Thanks again!! :) <br />
bye<br />
<div class="signature">"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love."    Pythagoras</div>

Luc Pattyn10-Dec-10 5:07

10-Dec-10 5:07

jadughar wrote:
actually i'm working with strings

Aha. Strings probably are the only situation where I might consider it, using a concatenation, i.e. calculate x+"#"+y at run-time, and have "0#1" and the like as switch case values (C# supports string-based switches, a lot of languages don't). It might be acceptable as the cost is limited and readability does not suffer at all.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

jadughar10-Dec-10 5:43

jadughar

10-Dec-10 5:43

Good idea!!!! Big Grin | :-D

Thanks Luc!!

"For as long as men massacre animals, they will kill each other. Indeed, he who sows the seed of murder and pain cannot reap joy and love." Pythagoras

Luc Pattyn10-Dec-10 5:45