Category Archives: ADO.NET

Reset an Access autonumber field in C#

Posted on March 7, 2016 by Rod Stephens

The post Get an autonumber value that was just inserted in C# explains how to use autonumbered fields. This post explains how you can reset the value used by an autonumber field. To reset an autonumber field in an Access … Continue reading →

Posted in ADO.NET, database | Tagged Access, ADO.NET, auto-increment, auto-number, autoincrement, autonumber, C#, C# programming, database, example, example program, reset, Windows Forms programming | 2 Comments

Get an autonumber value that was just inserted in C#

Posted on March 7, 2016 by Rod Stephens

If a database field is an autonumber field, then the database automatically generates values for it. For example, suppose a Students tables has typical fields such as FirstName, LastName, EnrollmentYear, and so forth. You could make the StudentId field be … Continue reading →

Posted in ADO.NET, database | Tagged Access, ADO.NET, auto-increment, auto-number, autoincrement, autonumber, C#, C# programming, database, example, example program, Windows Forms programming | 1 Comment

Use SQL queries to display master-detail data in C#

Posted on March 1, 2016 by Rod Stephens

This example uses SQL queries to load master-detail data only when it is needed. For quite a while now, the .NET-ish way to manipulate data from a database has been to load it into a DataSet stored in memory and … Continue reading →

Posted in ADO.NET, controls, database | Tagged ADO.NET, binding, C#, C# programming, child, controls, data binding, DataAdapter, database, DataGrid, DataSet, DataTable, detail, example, example program, master, master/detail, master/detail relationship, master/detail relationships, OldDbDataAdapter, OleDbCommandBuilder, OleDbConnection, parent, parent/child, parent/child relationship, relationships, Windows Forms programming | 4 Comments

Generate random data in an Access database in C#

Posted on February 28, 2016 by Rod Stephens

This example shows how you can generate random data for students and their test scores in an Access database. I often build examples that manipulate databases. Those examples are more interesting if the database holds lots of data, but it’s … Continue reading →

Posted in ADO.NET, algorithms, database | Tagged Access, ADO.NET, algorithms, C#, C# programming, database, example, example program, OLE DB, OleDbCommand, OleDbConnection, random, random data, randomization, Windows Forms programming | Leave a comment

Display master-detail data in a DataGrid in C#

Posted on February 26, 2016 by Rod Stephens

At design time, I added the example’s Contacts.mdb database to the project, set its “Build Action” property to Content, and set its “Copy to Output Directory” property to “Copy if newer.” That way the database is copied into the executable … Continue reading →

Posted in ADO.NET, controls, database | Tagged ADO.NET, binding, C#, C# programming, child, controls, data binding, DataAdapter, database, DataGrid, DataSet, DataTable, detail, example, example program, master, master/detail, master/detail relationship, master/detail relationships, OldDbDataAdapter, OleDbCommandBuilder, parent, parent/child, parent/child relationship, relationships, Windows Forms programming | 1 Comment

Execute ad hoc SQL commands in C#

Posted on November 27, 2014 by Rod Stephens

This example shows how you can execute ad hoc SQL commands such as CREATE TABLE and INSERT INTO in an Access 2007 database. ADO.NET itself doesn’t provide much in the way of objects to manipulate a database’s structure. Fortunately you … Continue reading →

Posted in ADO.NET, database, SQL | Tagged Access, Access 2007, ad hoc commands, ADO.NET, C#, C# programming, Connection, database, example, example program, OleDbCommand, SQL, Transact SQL, TSQL, Windows Forms programming | 2 Comments

Execute ad hoc SQL queries in C#

Posted on November 26, 2014 by Rod Stephens

This example shows how you can execute an ad hoc SQL query at run time. Normally a program uses Recordsets, DataGrids, LINQ to SQL objects, and other database objects and controls to display and manipulate database records. Those techniques tend … Continue reading →

Posted in ADO.NET, database, SQL | Tagged Access, Access 2007, ad hoc queries, ADO.NET, C#, C# programming, database, DataGridView, example, example program, SQL, Transact SQL, TSQL, Windows Forms programming | 3 Comments

Execute ad hoc database commands such as CREATE TABLE, INSERT INTO, DROP TABLE, and so forth in C#

Posted on July 13, 2014 by Rod Stephens

Visual Studio provides lots of data-aware controls that can help you display and edit data, but it doesn’t include much in the way of objects to manipulate a database’s structure. It doesn’t include objects or methods that let you easily … Continue reading →

Posted in ADO.NET, database | Tagged ad hoc database queries, ADO.NET, C#, C# programming, database, database queries, example, example program, queries, Windows Forms programming | Leave a comment

A plea for help: Tell me what you want to see in my blog!

Posted on May 22, 2014 by Rod Stephens

I get remarkably little feedback from my blog. I track post views and know that I have 857 Twitter followers, but people rarely let me know if they particularly like or dislike a post. That makes it hard for me … Continue reading →