This is what I Use It's For SQLite but basically the same concept.
public class Form1 : Form
{
private DataGrid Grid;
private SQLiteConnection sql_con;
private SQLiteCommand sql_cmd;
private SQLiteDataAdapter DB;
private DataSet DS = new DataSet();
private DataTable DT = new DataTable();
}
private void Form1_Load(object sender, EventArgs e)
{
LoadData();
}
private void LoadData()
{
SetConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "select Url, Url from rss";
DB = new SQLiteDataAdapter(CommandText,sql_con);
DS.Reset();
DB.Fill(DS);
DT= DS.Tables[0];
Grid.DataSource = DT;
sql_con.Close();
}
private void SetConnection()
{
sql_con = new SQLiteConnection("Data
Source=Rss.db;Version=3;New=False;Compress=True;");
}