C#

catch (Exception ex) {
    MessageBox.Show(ex.Message);
}

catch (Exception ex) {
    MessageBox.Show(ex.ToString());
}

Tunisien86 wrote:

but the exception still

NULLREFERENCEEXCEPTION IS UNHANDLED
Null ReferenceException

dr.Close();

Data Source=192.168.1.4,1433;Network Library=DBMSSOCN;Initial Catalog=GMAO;User ID=sa;Password=sa

Unknown connection option in connection string: network library.

private void Form6_Load(object sender, EventArgs e)
        {

            string sConnection = "Data Source=127.0.0.1,1433;Persist Security Info=True;Initial Catalog=GMAO;User ID=sa;Password=sa";
            string sSQL = "SELECT com FROM energie; ";
            SqlConnection conn = new SqlConnection(sConnection);
            SqlCommand comm = new SqlCommand(sSQL, conn);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            SqlDataReader dr = null;
            try
            {
                
                comm.Connection.Open();
                da.Fill(ds, "SQL Temp Table");
                foreach(DataRow d in ds.Tables[0].Rows)
                comboBox1.Items.Add(d.ToString());
            }
            catch (SqlException ex)
            {
                //MessageBox.Show("connexion impossible");
                MessageBox.Show(ex.Message);
                return;
            }

            dr.Close();
            comm.Connection.Close();
        }