1  string connectionString = string.Format("server=(local);uid=sa;pwd=1234567890;database=msp430");
 2 using (SqlConnection con = new SqlConnection(connectionString))
 3             {
 4                 con.Open();
 5                 SqlCommand cmd = new SqlCommand("UpdateData", con);
            
8                 cmd.CommandType = CommandType.StoredProcedure;
 9                 cmd.Parameters.Add("@shin", SqlDbType.Float).Value = Shine;
10                 cmd.Parameters.Add("@gas", SqlDbType.Float).Value = GasNondu;
11                 cmd.Parameters.Add("@temperature", SqlDbType.Float).Value = Temperature;
12                 cmd.Parameters.Add("@hui", SqlDbType.Float).Value = HuiChen;
13                 cmd.Parameters.Add("@time", SqlDbType.DateTime).Value = time;
14 
15 
16                 cmd.Parameters["@shin"].Direction = ParameterDirection.Input;
17                 cmd.Parameters["@shin"].DbType = DbType.String;
18                 cmd.Parameters["@gas"].Direction = ParameterDirection.Input;
19                 cmd.Parameters["@gas"].DbType = DbType.String;
20                 cmd.Parameters["@temperature"].Direction = ParameterDirection.Input;
21                 cmd.Parameters["@temperature"].DbType = DbType.String;
22                 cmd.Parameters["@hui"].Direction = ParameterDirection.Input;
23                 cmd.Parameters["@hui"].DbType = DbType.String;
24                 cmd.Parameters["@time"].Direction = ParameterDirection.Input;
25 
26                 cmd.ExecuteNonQuery();
27                 con.Close();
28             }