C# tutorial: Dictionary-C# code to connect database

Dictionary: C# code to connect to database file

The code below will help you to connect to the database file and retrieve data to put in the Lstterm listbox:

-Double-click on the form to open the code window

-You will see the code as shown below:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;


namespace KDictionary
{
public partial class Dic : Form


{
public Dic()
{
InitializeComponent();
}

private void Dic_Load(object sender, EventArgs e)
{

}
}
}

You need to add the statement Using System.Data.OleDb; to the Using group statements in the code above. So it will be come:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb ;

namespace KDictionary
{
public partial class Dic : Form


{
public Dic()
{
InitializeComponent();
}

private void Dic_Load(object sender, EventArgs e)
{

}
}
}

-Under the "public partial class Dic: Form" line type the following code:

private OleDbConnection cn;
private OleDbDataReader reader;
private OleDbCommand com;
private DataSet rs;
private OleDbDataAdapter ad;

This code will declare cn variable as the OleDbConnection class, reader variable as OleDbReader class, com variable as OleDbReader Class, rs variable as DatSet class, and ad as OleDbDataAdapter classs. These variables will be used to create their objects of their types.

-Create a method called myconnect by typing the code as shown below:

The search text box is set the focus to make sure that the cursor is active in this box for text input.

Txtbox.Focus();

By putting the method myconnect() in the form load event, the list box Lstterms will be populated by the English words:

private void Dic_Load(object sender, EventArgs e)
{
myconnect();

}

Note: we use try...catch block to catch any errors that may occur.

Now you have data filled in the list box Lstterms when the form loads. The next phase is to write some C# code to create a workable search text box.