Connecting a MySQL table to a DataGridView control in C#

Introduction

Since I started coding in grade 7 or so, I have worked with many programming languages and so far C# remains my favourite. (Java coming behind as a close second.) So when a small program is to be written, I prefer to choose C#. But if that program involves working with databases we are in a bit of a trouble. C# is naturally built to work with Microsoft SQL. But what if we do not want to sacrifice the freedom that we have with MySQL?

Connecting MySQL to .NET is a tricky thing. And it is a precondition to what I am going to write here. I would suggest you to go through this example and get some experience in connecting MySQL to .NET. I am going to build on it. 

Data Grid View

DataGridView is a cool windows forms component that can give you a grid view of your database tables similar to what you see in MS Access.

Read More

Source libre - Introduction

Since long, people have asked me why I do not write a tech blog. The answer was; “Because I do not have time”. The same reason is behind my beloved classical music blog not getting a new post for a long time. That problem is still there. But I thought it is high time that start writing techy stuff.

This blog will have small code snippets that I had to come up with to solve minor issues in projects that I am involved in. I will not be writing about complicated things here. Only small solutions for small problems. 

Let us see how it goes.

Oh, I almost forgot; "Source libre" means "open source" in French. Why French? Because French is a cool language. Why open source? Well, let us not talk about it, shall we?

(Image Sauce)

Read More