Tag Archives: Access

Save several images into Access in C#

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 , , , , , , , , , , , , , , , , , , | 1 Comment

Load images from an Access database in C#

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

Posted in database, graphics, image processing, Office | Tagged , , , , , , , , , , , , , , , , , | 2 Comments

Save images in an Access database in C#

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

Posted in database, graphics, image processing, Office | Tagged , , , , , , , , , , , , , , , , , | 4 Comments

Reset an Access autonumber field in C#

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 , , , , , , , , , , , , | Leave a comment

Get an autonumber value that was just inserted in C#

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 , , , , , , , , , , , | 1 Comment

Generate random data in an Access database in C#

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 , , , , , , , , , , , , , , | Leave a comment

Execute ad hoc SQL commands in C#

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 , , , , , , , , , , , , , , | 2 Comments

Execute ad hoc SQL queries in C#

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 , , , , , , , , , , , , , | 3 Comments