I can understand if you are developing a POS system you may want this input to be directed to the textbox. You could always try setting the KeyPreview to True on the Form. Then on the KeyPress you could try

    private void YourForm\_KeyPress(object sender, KeyPressEventArgs e)
    {
        ScannerFirstKeyValue = e.KeyChar.ToString();

        if (this.ActiveControl != this.YourTextBox)
        {
            YourTextBox.AppendText(ScannerFirstKeyValue);
        }
        this.ActiveControl = YourTextBox;
    }

This would ensure all input is placed in correct textbox. Remember if you have multiple textboxes this will be a problem!! Unless the BC Reader has some sort of prefix that can distinguish it from a keyboard.

Regards Mick Curley :)

You could always create a windows application using VS(assuming you use it). Place whatever components you require on the form. Then have a look at the YourForm.designer.cs files. This will give you all the necessary info on creating the various controls. Next investigate Drawing,DragDrop using the mouse. Finally you will need to save this info (control type,position etc) in some type of file XML etc. After all this you should have yourself a pretty fine GUI Editor. Best of luck

Regards Mick Curley :)

Take it easy there my friend.. Mark is simply saying you could have googled this, but just to get you started the functionality you require is hidden away under :

DataGridView.Rows[rowindex].Selected = true;

On another note, people won't help you if your're rude.

Regards Mick Curley :)

Create a bool on MDI2, set it to true if data is edited. Create a readonly property for this bool on MDI2 and check it from MDI1. Refresh if true.

Regards Mick Curley :)

Hi My two cents.. I don't know much about this service but I use .Net Reactor. I find it flexible enough and doesn't obstruct application performance, so far.. Support can be a little slow, but overall thumbs up.

Regards Mick Curley :)

Hi, You should post this in the Mobile Development section. You need to contact your device manufacturer to obtain an SDK or utility for that device.

Regards Mick Curley :)

Good to hear..

Regards Mick Curley :)

I dont understand what your trying to do. If you load the data from your Database table into a DataTable haven't you got a reference to the columns within that DataTable?

Regards Mick Curley :)

I would create a datatable and point the datagridview to it

DataTable DT = new DataTable();

foreach (string s in default_columns)
{
DataColumn NewCol = new DataColumn(s);
DT.Columns.Add(NewCol);
}

DataGridView.DataSource = DT;

Regards Mick Curley :)

Create an integer variable. Then load the datagrid and select the first row by using

dataGrid.Select(0)

Then capture the up and down keys on the form and increment or decrement this variable and pass this to the dataGrid

dataGrid.Select(your_variable_here)

Would this not achieve what you want to do?

Regards Mick Curley :)

Just use the Mouse or Click Events exposed by the datagrid. and get its CurrentRowIndex. You may have to bind the datagrid datasource using the CurrencyManager. Then just build a DataRowView from it. I'm not sure if this is what you are asking. BTW. you should post this in Mobile Development. Regards M Curley. :)

Hello What about using a LinkLabel. Bye

How are you loading the form ?? At Startup or from Application...

I would try to put the file in a location like "C:\\Myfolder" just to test eliminate the "Program files" directory and see what happens, also punch in the path manually Data Source= C:\Myfolder\Daily_Totals_By_Employee.xls See if any of those work...sorry I can't be any more specific...

HDR=Yes; Indicates that there are header rows in the sheet, and IMEX=1; 0 Export mode, 1 Import mode, 2 Linked mode, I run Imports from excel in 98/XP/Vista with that connection and its all good. How are you defining your path ie:Filename??

Try using this as a connection string instead "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties = 'Excel 8.0;HDR=Yes;IMEX=1'"; I am going with the presumption that "filename" is an actual path and "Sheet1" does exist in all cases.... butyou know what they say about presumptions ;)

If your firing a thread off ever second, I would suggest the BackgroundWorker its a lot easier to manage. You could check if its busy on each Tick and fire it off again if not.

A craft is an enemy if not well learned.

You could always use .NET Reactor, it merges the application with native code. It stops any decompiling according to the website.

A craft is an enemy if not well learned.

You could also fill a datatable from from the excel spreadsheet (ExcelDT) and also fill another datatable from the Access Table (AccessDT). Then just use a foreach loop on the excel datatable:

     foreach (DataRow row in ExcelDT.Rows)
     {          
        DataRow newrow = AccessDT.NewRow();

        newrow.ItemArray = row.ItemArray;           
        
        AccessDT.Rows.Add(newrow);

     }

Finally call update on the AccessDT and Bingo your done :) Hope this helps.

A craft is an enemy if not well learned.

Its on your form closing event, you need to add code to cancel/continue..I presume something like the following. private void FormClosing(object sender, CancelEventArgs e) { if (MessageBox.Show("Are you sure you want to exit?", "Confirm exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { e.Cancel = true; } }

A craft is an enemy if not well learned.