Search:

Use DataAdapter.Update()

I have structure our version control structure like this:

Root (All solution files here)
- Database (Database scripts)
- Design (Design documents)
- External (External DLL:s, 3rd party...

Try running the query from Access directly (create a new query and switch to SQL view to enter SQL code in access).

I don't know any built-in function for this, I would have used a Merge algorithm, search for Merge or MergeSort and you will find lots of examples.

Yes, it can be done using System.Reflection.

I suggest creating a separate class hierarchy for those things that are "static"; say you have Page and PageTemplate, LeftPage and LeftPageTemplate etc. the TemplatePage class could hold those...

It is fairly easy to write an application to do this in VB 6.0 or .Net (like C# or VB.Net).

A lot of tools can extract the information for you as well, like Visio, Enterprise Architect from Sparx...

The flags attribute controls how the enum is converted to a string, and how a property grid can convert a string to an enum. Nothing else. (Except telling other programmers that this it is a flag.)

private object MyMethod(ResponseHandler handler, object[] arguments)
{
// Do something
}

...
ResponseHandler rh = new ResponseHandler(...);
ResponseProxy rp = new ResponseProxy(MyMethod,...

You can use either ADO .Net transaction or System.Transactions. Look at MSDN for examples.

Another thing to look at is games, really simple games, or perhaps solitaire games.

I have seen a lot of programmers in C# and Java that not have grasped the concepts of OOP, and the result is...

One additional idea, if you are going down this route, writing generic database code, I suggest using reflection all the way.

You could:
a) reflect all properties of the class you are loading...

Try something like:




GetType().GetProperty("Property1").SetValue(this, table.rows[0][Column.ColumnName], null);

I have not used XAML but if two controls are bound to the same property of your data source then either control should change once the other control changes the property in the data source.

I tried this code and it worked fine:



private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("T1", typeof(int)));
...

Which events?

You can subscribe to events of objects in the list before or after they are added to the list.

You can use System.ComponentModel.BindingList<T> which implements the IBindingList...

1) Note that System.ComponentModel.BindingList<T> implements events for a list.

2) The only ways I can think of to do this is to

a) define or use an existing interface (such as...

Well database file can be created from code, access path can be defined by code, and in a single user scenario perhaps you don't have to bother with permissions (but that depends on the requirements...

I think the Jet database engine (Access MDB files) has a few advantages:

- It does not require any database installation
- It is quite fast for most single user scenarios
- It is easy to...

Does this help? http://support.microsoft.com/kb/317114

Add a Panel to the Form. Dock it to the left. Set Dock to Fill for the FlowLayoutPanel. Skip the resize events.

Yes, that's the way to go. An alternative way is to pass the string for the select command and the connection string or the connection object to the constructor of the data adapter.

Have you set the select command object of the data adapter?

I have solved it in the same way, in my app I have a tree view that could contain a lot of items from the DB and it would take to long time to populate the entire tree view.

When I add new nodes...

Well, with my code you don't have to add the root node first, all nodes are added in the populate method.

The ?: operator in C# corresponds to the Iif function in VB, however Iif will evaluate...