C#

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();
   SqlCeDataAdapter da = new SqlCeDataAdapter();
   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();
  }

Tunisien86 wrote:

In fact,my combobox should contain the result of my select statement,but when running,the system is show an sqlexception and nothing is added to my combobox.

string sSQL = "SELECT DISTINCT * FROM [D°_urgence]";

Tunisien86 wrote:

Or should I take the physical @ as the @ of my computer?

I are Troll

Error 1335. The cabinet file 'product.cab' required for this installation is
corrupt and cannot be used..."

Tunisien86 wrote:

When should I uncradle my emulator???

Tunisien86 wrote:

When trying to install windows mobile device center,it failed.Should i connect a real device to be able to install this tool???

Tunisien86 wrote:

How can I get the IP number that is used for my device and PC for this TCP/IP connection??????

I are Troll

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();
        }