C#上位机读数据库

  string connectionString = string.Format("server=(local);uid=sa;pwd=1234567890;database=msp430");

 using (SqlConnection con = new SqlConnection(connectionString))

             {

                 con.Open();

                 SqlCommand cmd = new SqlCommand("UpdateData", con);

                 cmd.CommandType = CommandType.StoredProcedure;

                 cmd.Parameters.Add("@shin", SqlDbType.Float).Value = Shine;
                 cmd.Parameters.Add("@gas", SqlDbType.Float).Value = GasNondu;

                 cmd.Parameters.Add("@temperature", SqlDbType.Float).Value = Temperature;

                 cmd.Parameters.Add("@hui", SqlDbType.Float).Value = HuiChen;

                 cmd.Parameters.Add("@time", SqlDbType.DateTime).Value = time;

                 cmd.Parameters["@shin"].Direction = ParameterDirection.Input;

                 cmd.Parameters["@shin"].DbType = DbType.String;

                 cmd.Parameters["@gas"].Direction = ParameterDirection.Input;

                 cmd.Parameters["@gas"].DbType = DbType.String;

                 cmd.Parameters["@temperature"].Direction = ParameterDirection.Input;

                 cmd.Parameters["@temperature"].DbType = DbType.String;

                 cmd.Parameters["@hui"].Direction = ParameterDirection.Input;

                 cmd.Parameters["@hui"].DbType = DbType.String;

                 cmd.Parameters["@time"].Direction = ParameterDirection.Input;

                 cmd.ExecuteNonQuery();

                 con.Close();

             }