Tag Archives: Access

Use a password protected Access database in C#

Posted on May 10, 2018 by RodStephens

This example shows how you can open and use a password protected Access database in C#. It also shows how you can use the database’s password protection to provide a login form for your program. Note that the security used … Continue reading →

Posted in database, Office | Tagged Access, C#, C# programming, database, example, example program, Office, password protected Access database, passwords, Windows Forms programming | Leave a comment

Display database pictures in a ListView control in C#

Posted on April 6, 2018 by Rod Stephens

This example shows how you can display database pictures in a ListView control. My previous post, Create ListView icons at run time in C#, explained how to make images at runtime to display in a ListView control. This example follows … Continue reading →

Posted in controls, user interface | Tagged Access, C#, C# programming, controls, database, Details, display database pictures, example, example program, icons, LargeIcon, list, ListView, ListView icons, Microsoft Access, SmallIcon, tile, user interface, View, Windows Forms programming | 10 Comments

Save several images into Access in C#

Posted on May 12, 2017 by Rod Stephens

The example Save images in an Access database in C# includes an Access database. Unfortunately if you save several images into the database and then open the database in Access, Access removes the images. It just doesn’t seem to understand … Continue reading →

Posted in database, graphics, image processing, Office | Tagged Access, C#, C# programming, database, example, example program, graphics, image, image file, image processing, initialize list, list, ListBox, Microsoft Access, Office, picture, save images, save several images, Windows Forms programming | 1 Comment

Load images from an Access database in C#

Posted on May 10, 2017 by Rod Stephens

The post Save images in an Access database in C# explains how to save images in an Access database. This post explains how to load images from an Access display them. Like previous examples, this program uses a SQL statement … Continue reading →

Save images in an Access database in C#

Posted on May 9, 2017 by Rod Stephens

This example shows how you can save images in an Access database. The example Use filenames stored in a database to display images in C# shows how to display images by saving the image file names in a database and … Continue reading →

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

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

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 →