Hello, Why would someone use this technique instead of letting apps directly query the MySQL server? Are there any security benefits or what? Thanks, Adrian

It just didn't cross my mind to order by ID. :) Thanks!

Hi guys, I've searched google but didn't find anything regarding this issue. I'm updating an MS Access table after reading some fields from the same table. While doing this i have a label to check how many rows have been processed out of total and i see that the reader jumps from an ID to another, process a few rows then comes back to the ID before jump happened. Is this thing normal? The table is created from an imported text file using Access.Application.DoCmd.TransferText. I thought compacting the database after import will fix this, but didn't. Any ideas? Thank you!

Hello, Can anyone tell me how to use a List of strings inside a struct? I get the 'Object reference not set to an instance of an object.' error.

    public Form1()
    {
        InitializeComponent();
    }

    struct testStruct
    {
        public List<string> sList
        {
            get;
            set;
        }

    }

    private void Form1\_Load(object sender, EventArgs e)
    {
        testStruct aTestStruct = new testStruct();
        aTestStruct.sList.Add("test");
    }

Thank you!

Here is how i would do it:

       foreach (string f in Directory.GetFiles(@"C:\\MyFolder")) 
        {
            if (f.EndsWith(".xml")) 
            {
                string currentf = f.Substring(f.LastIndexOf('\\\\') + 1); 
                File.Move(f, @"C:\\MyFolder\\MyXmlFolder\\" + currentf); 
            }
        }

It iterates through every file in MyFolder and if it's an xml then move it to MyXmlFolder.

Thanks a lot!

Hello! I am trying to understand more about threading but i can't find how to 'free' the UI from the threads working in the background. How can i use my form's controls or move/resize the window while a progressbar is updated from a loop in another thread? Here is the code:

    delegate void \_delegate(); 

    private void button1\_Click(object sender, EventArgs e)
    {
        Thread t1 = new Thread(new ThreadStart(ProgressUpdate));
        t1.Start();
    }

    void ProgressUpdate()
    {
        if (progressBar1.InvokeRequired)
        {
            progressBar1.Invoke(new \_delegate(Progress));    
        }

        else
        {
            for (int i = 1; i <= 100; i++)
            {
                progressBar1.Value = (i \* 100) / 100;
                Thread.Sleep(50);
            }
        }
    }

    void Progress()
    {
        for (int i = 1; i <= 100; i++)
        {
            progressBar1.Value = i;
            Thread.Sleep(50);
        }
    }

Hello! I am using the windows context menu. My problem is that when i select multiple files the application will open as many times as selected files. In HKEY_CLASSES_ROOT\*\shell i have a key with the shortcut to my app and %1. Should the "%1" parameter be changed? Using the "SendTo" and creating a shortcut to the application will work as i wish, but how can i make it work the same way "SendTo" works for the context menu? I hope i made myself understood. I know this is more of a windows problem and not a C# one. Thanks!

You can try numbers.Contains(intRnd). Hope this helps. Good luck!

Hello! I am quite new to programming. I have no ideea how to cancel these 'automatic' key events that rise from hiting 'enter' or 'space' on a button but here is how i would do it: Set button's 'TabStop' to false. Create an 'enter' event and put this inside the event: SelectNextControl(yourbuttoncontrolhere, true, true, true, true); This won't allow the user to focus the control in any way but it will allow him to click the button. Hope this helps, Good luck!

Hello! I'm working on an application wich will alow the user to add and remove controls. I want to apply different rules to textbox and this rules will be different for every textbox. For example i want to check wich control has been clicked by using a click event. Because i don't know how many textboxes will the user create i've decided to go along with the code below:

    private void Form1\_Load(object sender, EventArgs e)
    {
        foreach (Control ctrl in Controls)
        {
            ctrl.Click += new EventHandler(ctrl\_Click);
        }
    }

    void ctrl\_Click(object sender, EventArgs e)
    {

    }

Is there anyway that i can get the name of the control that has been clicked? The sender.Tostring() only returns the type and the text of the control. Thanks! ;)