Here's my toolbox boilerplate code:
string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("MyDBName");
string sql = "SELECT Id, Desc FROM MyTable";
using (SqlConnection con = new SqlConnection(strConnect))
{
try
{
con.Open();
using (SqlDataAdapter da = new SqlDataAdapter(sql, con))
{
using (DataTable dt = new DataTable())
{
da.Fill(dt);
myDataGridView.DataSource = dt;
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
The connection string comes from a "common source" datafile:
Instance Storage - A Simple Way to Share Configuration Data among Applications[
^] - that may be overkill for you, so this may also help:
Simple SQL Connection String Creation[
^]