C#

yefeng_law wrote:

I am just hoping I could be able to get help.

yefeng_law wrote:

I also try another method which is directly from the usb port which the device is connected to but i am unable to start working on it coding

public class DatabaseAccess
{
    public static DataTable OpenQuery(string query)
    {
        OleDbCommand cmd;
        OleDbConnection cnn;
        OleDbDataAdapter da;
        DataSet ds;
        DataTable table;

        try
        {
            cnn = new OleDbConnection(YOUR_CONNECTION_STRING);
            cmd = new OleDbCommand(query, cnn);
            cmd.CommandType = CommandType.Text;
            cnn.Open();
            da = new OleDbDataAdapter(cmd);
            ds = new DataSet();
            da.Fill(ds);
            table = ds.Tables[0];
            cnn.Close();
            cnn.Dispose();
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
        return table;
    }
}

grid1.DataSource = DatabaseAccess.OpenQuery("SELECT ... FROM...");

Rafone wrote:

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...