Comments by Grant Mc (Top 17 by date)

Thanks for this, looks like a great starting point for me.

Thank you, your answer is very well written.

The reason I was to display an image is to show how I want columns to appear in a datagrid or treelist.

I will try and find a way to word my question later on in the week.

Thank you.

Many thanks Sergey

Would the only other alternative be SQL?

The database is on a network drive. Copied to a local drive and the time reduced to 1 minute and 1 second.

I am using System.Data.OleDb.OleDbDataAdapter, would you suggest using something else?

public OleDbDataAdapter products_Adapter;
public OleDbDataAdapter batches_Adapter;
public DataTable products_Table;
public DataTable batches_Table;
public OleDbCommandBuilder builder;
public OleDbConnection connection;

public Database()
{
connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Database.mdb");
connection.Open();

products_Table = new DataTable();
batches_Table = new DataTable();

products_Adapter = new OleDbDataAdapter("SELECT * FROM TblProducts", connection);
products_Adapter.Fill(products_Table);
builder = new OleDbCommandBuilder(products_Adapter);
products_Adapter.UpdateCommand = builder.GetUpdateCommand();
products_Adapter.InsertCommand = builder.GetInsertCommand();
products_Adapter.DeleteCommand = builder.GetDeleteCommand();

batches_Adapter = new OleDbDataAdapter("SELECT * FROM TblBatches", connection);
batches_Adapter.Fill(batches_Table);
builder = new OleDbCommandBuilder(batches_Adapter);
batches_Adapter.UpdateCommand = builder.GetUpdateCommand();
batches_Adapter.InsertCommand = builder.GetInsertCommand();
batches_Adapter.DeleteCommand = builder.GetDeleteCommand();
}

public void Save()
{
products_Adapter.Update(products_Table);
batches_Adapter.Update(batches_Table);
}

Hi Bill, I would love to see what you think what would work better.

It would be great to see how how to synchronize the values, even if I don't use it for this project. Just to learn what can be done

Thanks.
Grant

Your help is really appreciated.

Thank you very much

I have tried this, but it does not seem to work.
public class MyGrid
{
public List<column> Columns = new List<column>();
public int DefaultColumnWidth = 64;

public void Test()
{
Columns.Add(new Column());
int x;
x = Columns[0].Width; // returns 64
DefaultColumnWidth = 10;
x = Columns[0].Width; // returns 64
}
}

public class Column : MyGrid
{
private int width = -1;

public int Width
{
get
{
if (width >= 0)
return width;
else
return base.DefaultColumnWidth;
}
set
{
width = value;
}
}
}

I really appreciate this, thank you very much.

Figured it out.

I thought that because it was static that I did not have to do
Database = new FileInfo()

Thanks for everyone's assistance.
I have learned something for today.

OK, still a little confused. I now have this

public partial class Form1:Form
{
public void Test()
{
Settings.Database.Location = "Test"; // This produces a error
}

public static class Settings
{
public static FileInfo Database;
public static XmlDocument Document;
private static XmlElement Element;
}

public class FileInfo
{
public string Location = "Test";
public DateTime Date;
}


But it produces a runtime error
System.NullReferenceException

Why is it doing this please?

So why am I allowed to to create an instance of the XmlDocument etc?

Thanks for your assistance.