Re: Looping though Dataset - C# Discussion Boards

ncc1701e25-Feb-09 3:38

25-Feb-09 3:38

Hi,

I am trying to create a tool using c# which hides and locks folders similar to LockBox. This means that the hidden folder will be invisible to EVERYONE when protected, and visible when a password is entered. In code project there is an example using windows shell folders which actually "locks" the folder - but the problem is that it still is 1) Visible and 2) accessable through windows command prompt.

Thanks a lot Smile | :)

Re: Folder Lock and Hiding.

EliottA25-Feb-09 5:35

EliottA

25-Feb-09 5:35

Ok. I didn't see one question there.

Check out the CodeProject forum Guidelines[^]

Re: Folder Lock and Hiding.

Curtis Schlak.25-Feb-09 9:23

Curtis Schlak.

25-Feb-09 9:23

He's just bragging. : )

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: Folder Lock and Hiding.

EliottA25-Feb-09 9:37

EliottA

25-Feb-09 9:37

What a tease.

Check out the CodeProject forum Guidelines[^]

Re: Folder Lock and Hiding.

ncc1701e27-Feb-09 1:29

ncc1701e

27-Feb-09 1:29

Ups ... you're right... I was just last in thinking lol..

So the question is. Is there anyway to do this in C# without using the mentioned methods above in my first post?

Re: Folder Lock and Hiding.

archananaresh29-Mar-09 19:14

archananaresh

29-Mar-09 19:14

Hello sir,
your question is interesting ....
Even iam trying with similar stuff...If your succeeded in doing this, please help me out.
Thankyou sir

Looping though Dataset

kanchoette25-Feb-09 3:16

kanchoette

25-Feb-09 3:16

I have a boolean value in a dataset bound to a checkbox control

If the user clicks on the checkbox I want to loop through the dataset and set the boolean to false for all other rows. In other words only one of the rows in the dataset/databinding can have the boolean field set to true.

How can I achieve this please?

I had thought to use something like:

foreach (DebtorDataSet.GuarantorRow grow in DebtorDataSet.Guarantor.Rows)
{
test this row against the current databinding.position/current somehow and set the boolean for this row accordingly
}

Not sure how to actually implement it though Blush | :O

Re: Looping though Dataset

Xmen Real 25-Feb-09 3:29

Xmen Real

25-Feb-09 3:29

DataSet never have Rows... what is DebtorDataSet.GuarantorRow WTF | :WTF:

?? are you using 3rd party controls ?

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Re: Looping though Dataset

kanchoette25-Feb-09 3:32

kanchoette

25-Feb-09 3:32

My apologies. It is a datatable which is part of a dataset.

Re: Looping though Dataset

Xmen Real 25-Feb-09 4:25

Xmen Real

25-Feb-09 4:25

I dont understand your question

kanchoette wrote:
...bound to a checkbox control

If there is a checkbox then what ?

kanchoette wrote:
...set the boolean to false for all other rows.

other rows... Confused | :confused:

Re: Looping though Dataset

PIEBALDconsult25-Feb-09 3:35

PIEBALDconsult

25-Feb-09 3:35

Don't you have a key?

Re: Looping though Dataset

ABitSmart25-Feb-09 3:35

ABitSmart

25-Feb-09 3:35

Just a suggestion, the functionality you mentioned is more of a radiobutton kind. Generally, checkbox is used to enable multiple selection and it could be misleading to use it for the usecase.

As I already said, it's just a suggestion Smile | :)

Re: Looping though Dataset

kanchoette25-Feb-09 3:44

kanchoette

25-Feb-09 3:44

I agree that a radio button would make more sense, but I have to use a checkbox to fit in with the rest of my project. Any thoughts on how to go about it please?

Re: Looping though Dataset

ABitSmart25-Feb-09 4:10

ABitSmart

25-Feb-09 4:10

i suggested checkbox as i think that it will automatically be handled. since,if you group a checkbox, only one can be set and others are reset automatically.

Edit - Saying that, I do not know how it will behave in databinding

How to add a ScrollBar where there is none?

Megidolaon25-Feb-09 3:12

Megidolaon

25-Feb-09 3:12

I want to read an image and display its content in PictureBoxes.
The PictureBoxes get added dynamcally to a Panel (or is there a better control to keep them all together?) dpending on the image size.
The PictureBoxes all have a size of 32x32 pixels.

If you ever used an rpg maker, I'm trying to make some map maker wher you can see the source image on the left side, select a tile and then edit the map on the right side with it.

I have 2 problems, first and foremost I added a ScrollBar to the control and to the Controls property of the Panel.
Obviously nothing happens when you scroll, though you are supposed to be able to scroll up and down when the source image is too large to display at once.

How can I get the ScrollBar to make the Panel display a different part of the source image, whenever you scroll?

I thought of clearing the Controls property of the Panel and always just adding the visible PictureBoxes (they all are stored in an extra collection), determining which ones are visible by Panel and PictureBox size.
Though, this would need calculations and have to be pixel-exact, if possible I dould like to avoid this and use a more elegant way.

The second problem is that I have a for loop which is repeated once for image width/32 (8 times, I intend to have a fixed width of 256 pixels) and adds a PictureBox everytime (again, 8).
The problem is that 8.5 PictureBoxes are display in width, the half PictureBox seems to be downscaled version:
http://i43.tinypic.com/snhyjc.jpg[^]

Re: How to add a ScrollBar where there is none?

Xmen Real 25-Feb-09 3:19

Xmen Real

25-Feb-09 3:19

Megidolaon wrote:
I added a ScrollBar to the control and to the Controls property of the Panel.

You dont need to put ScrollBar control in panel, just set AutoScroll Property of panel to True

Megidolaon wrote:
I thought of clearing the Controls property of the Panel and always just adding the visible PictureBoxes (they all are stored in an extra collection), determining which ones are visible by Panel and PictureBox size.Though, this would need calculations and have to be pixel-exact, if possible I dould like to avoid this and use a more elegant way.

Try FlowLayoutPanel

Re: How to add a ScrollBar where there is none? [modified]

Megidolaon25-Feb-09 21:23

Megidolaon

25-Feb-09 21:23

Thanks, the FlowLayoutPanel is exactly what I need.

Though, the second problem is there, the PictueBoxes have a weird layout and weird images, what confuses me the most is that most of the tme it seems to work, but some seem corrupted.

This is the original image (256 x 2000 pixel):
http://i43.tinypic.com/10qjng4.jpg[^]

This is what the PictureBoxes look like(the black lines are the PictureBoxes' FixedSingle Border):
http://i42.tinypic.com/1677e44.jpg[^]

The code I use to assign the images to the PictureBoxes:

g.DrawImage(resource, new Rectangle(0, 0, 32, 32), 
   new Rectangle(32 * i, 32 * k, 32, 32), GraphicsUnit.Pixel);

Where i is the counter for the height(0-7) and k is the counter for the height (0-63).
I have 2 nested for loops, the outer one for the width and the inner one for the height.
I store the PictureBoxes in a Dictionary<point,picturebox>;. I already checked but I create a new Point for ever PictureBox and the coordinates are unique.

modified on Thursday, February 26, 2009 3:48 AM

Re: How to add a ScrollBar where there is none?

Xmen Real 25-Feb-09 23:01

Xmen Real

25-Feb-09 23:01

you mean the half gray square is the problem ? if yes then I just noticed something that this is happening after every 8th boxes...in other words its happening at the end of patterned boxes. Its hard to findout problem without seeing code...

Re: How to add a ScrollBar where there is none?

Megidolaon25-Feb-09 23:41

Megidolaon

25-Feb-09 23:41

ok, this is the code:

for (int i = 0; i <= width; i++)
            {
                for (int k = 0; k <= height; k++)
                {
                    if (i == 7 && k == 15)
                    {
                        this.Text = this.Text;
                    }
                    g = Graphics.FromImage(memory);

                    coordinate = new Point(i, k);
                    pictureboxes.Add(coordinate, new PictureBox());
                    pictureboxes[coordinate].Height = 32;
                    pictureboxes[coordinate].Width = 32;
                    pictureboxes[coordinate].Visible = true;
                    pictureboxes[coordinate].Anchor = AnchorStyles.Left | AnchorStyles.Top;
                    pictureboxes[coordinate].BorderStyle = BorderStyle.FixedSingle;
                    pictureboxes[coordinate].Margin = new Padding(0);

                    pictureboxes[coordinate].Location = new Point(32 * i, 32 * k);

                    pictureboxes[coordinate].MouseDown += new MouseEventHandler(OnLeftDown);
                    pictureboxes[coordinate].MouseDown += new MouseEventHandler(OnRightClick);

                    g.DrawImage(resource, new Rectangle(0, 0, 32, 32), 
                        new Rectangle(32 * i, 32 * k, 32, 32), GraphicsUnit.Pixel);
                    
                    pictureboxes[coordinate].Image = new Bitmap(memory, new Size(32, 32));

                    FLP_Resource.Controls.Add(pictureboxes[coordinate]);
                }

FLP_Resource is the FlowLayoutPanel and pictureboxes is a dictionary[Point, PictureBox] in which I store the PictureBoxes.

Since you can't choose which part of an image is assign to a PictureBox, but can only assign the whole image, I used a Graphics object to draw a certain part of the source image on a memory Bitmap (which I will later resize and use for double buffering).
I first get the desired part of the source image and then assign it to a PictureBox.

Re: How to add a ScrollBar where there is none?

Xmen Real 25-Feb-09 23:47

Xmen Real

25-Feb-09 23:47

well I really dont understand what you want actually but I'm sure you are making this very complicated. Why you are using Dictionary. You can use List<PictureBox>.

Megidolaon wrote:
Since you can't choose which part of an image is assign to a PictureBox

what that mean ?

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Re: How to add a ScrollBar where there is none?

Megidolaon26-Feb-09 2:02

Megidolaon

26-Feb-09 2:02

So that I ensure I have only 1 PictureBox for each coordinate.
In a List I could end up having with 2 PictureBoxes having the same coordiantes.

Xmen wrote:
what that mean ?

When you assign the Image property of a PictureBox, you can only assign the whole image, in my case that would be the whole 256x2000 pixel source image.
What I want is to split that image into 32x32 pixel tiles and assign each of these tiles to a different PictureBox, so you can click on and select each separately.

Then you can paste the 32x32 tiles and build your map with them.

Re: How to add a ScrollBar where there is none?

Xmen Real 26-Feb-09 2:49

Xmen Real

26-Feb-09 2:49

Megidolaon wrote:
So that I ensure I have only 1 PictureBox for each coordinate.In a List I could end up having with 2 PictureBoxes having the same coordiantes.

That mean you are scaring to write a little more code that will validate. Its quite simple, if you dont want to put multiple pictureboxes at same point then you can just iterate through previous pictureboxes' location. BTW I dont think you will get same point again if you try to write a good code (No need for validation) Wink | ;)

Megidolaon wrote:
When you assign the Image property of a PictureBox, you can only assign the whole image, in my case that would be the whole 256x2000 pixel source image.What I want is to split that image into 32x32 pixel tiles and assign each of these tiles to a different PictureBox, so you can click on and select each separately.Then you can paste the 32x32 tiles and build your map with them.

2000 cant be divide by 32, your image must have 2048 height if you gonna tile of 32 x 32

OoO Well, once I wrote a code similar to this but I just used a single PictureBox.
What you need to do is use the MouseClick events of PictureBox. In MouseClick, grab the cursor position, round the position to least tile position and rip it from image.

eg
Cursor Position : 35, 126
Nearest Tile Position(by rounding) : 32, 96

If you are unable to write code to round, just give a bell Wink | ;)

An advice, do not set Image in Image property, use BackgroundImage instead, therefore you can use BackgroundImageLayout and avoid lots of hassles.

Re: How to add a ScrollBar where there is none? [modified]

Megidolaon26-Feb-09 20:49

Megidolaon

26-Feb-09 20:49

As for the PictureBox coordinates, I program by the motto "better save than sorry".
I try to avoid even theoretically impossible situations, like slightly wrong named files (since I'm the only one that names the files), even if such a situation should never happen, I know in the rare case it does (if I forgot the guidelines I made up or whatever), the program will still work fine.
The dictionary works god, I'll just leave it lie that.

Xmen wrote:
2000 cant be divide by 32, your image must have 2048 height if you gonna tile of 32 x 32

I use the Math.Ceiling() method to add enough PictureBoxes to contain images that aren't dividable by 32 and the Image property of the PictureBoxes at the edges should contain the last bit of the source image.
I want to keep the source image size a bit flexible.

Xmen wrote:
Cursor Position : 35, 126
Nearest Tile Position(by rounding) : 32, 96

I already used the MouseDown event to determine which PictureBox was clicked on and changed its BorderStyle.
I laos determined whichPictureBox was last clicked on and changed its BorderStyle back to None, to highlight only the one you clicked on last.

Xmen wrote:
An advice, do not set Image in Image property, use BackgroundImage instead, therefore you can use BackgroundImageLayout and avoid lots of hassles.

I used

pictureboxes[coordinate].BackgroundImageLayout = ImageLayout.Tile;

and tried all available ImageLayouts, with an without my own code.
All PictureBoxes were white and I had a weird smear effect where the the Borders of the PictureBoxes smeared about an inch on the right side of the form, outside the FlowLayoutPanel.

I got it right now, I adjusted my loops and changed a bit, the PictureBoxes were all over the place, with some not even being displayed (I found that out by numbering a few), but now everything is fine.

I even painted the last PictureBoxes first with the BackColor of the form (through a Pen's Brush property) and now it looks like only the source image is displayed.

Re: How to add a ScrollBar where there is none?

Xmen Real 27-Feb-09 1:37

Xmen Real

27-Feb-09 1:37

Since you got it work, no further answers Wink | ;)

if you wanna check mine one, here is the link[^]

Re: How to add a ScrollBar where there is none? [modified]

Megidolaon1-Mar-09 20:30

Megidolaon

1-Mar-09 20:30

Thanks a lot, you helped me a great deal. Wink | ;)

I had a problem with the FlowLayoutPanel, which kept me from displaying the PictureBoxes properly, the FlowLayoutPanel overrides the actual location and changes it according to FlowLayout.

I switched to a normal Panel.
I had a problem where even when setting the AutoScroll peroptery to true, it woudn't add any scrollbars, even if I had many more PictureBoxes then could be displayed at once.
However, I copypasted a Panel from a codeproject article (seemingly the same as mine) and suddenly it worked.
Now my Panel doesn't change the location and adds scrollbars that allow you to scrll arund if the amount of PictureBoxes is too large to display at once.

modified on Monday, March 2, 2009 6:07 AM

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