自由手記

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

try
     {
            string String1 = "[ShoesParty].[dbo].[IVNO] (IVyear,IVmonth,IVword,IVnumS,IVnumE,IVnow) ";
            string String2 = " VALUES(@IVyear,@IVmonth,@IVword,@IVnumS,@IVnumE,@IVnow)";
            string String3 = "INSERT INTO " + String1 + String2;
            SqlConnection sqlcon =new SqlConnection("Data Source=...;Initial Catalog=;User Id=;Password=");
            sqlcon.Open();
            SqlCommand sqlcom = new SqlCommand(String3, sqlcon);
            sqlcom.Parameters.Add("@IVyear", SqlDbType.NVarChar).Value = "103";
            sqlcom.Parameters.Add("@IVmonth", SqlDbType.NVarChar).Value = "02,04,";
            sqlcom.Parameters.Add("@IVword", SqlDbType.NVarChar).Value = "AS";
            sqlcom.Parameters.Add("@IVnumS", SqlDbType.Int).Value = "22";
            sqlcom.Parameters.Add("@IVnumE", SqlDbType.Int).Value = "33";
            sqlcom.Parameters.Add("@IVnow", SqlDbType.Int).Value = "44";
            sqlcom.ExecuteNonQuery();
            sqlcom.Dispose();
            sqlcon.Close();
            sqlcon.Dispose();
     }
     catch (Exception e)
     {
        
     }