如何将数据插入到SQL Server Express数据库中

Question

如何将数据添加到SQL Server Express数据库中？

我写了下面的代码

SqlConnection conn = new SqlConnection(); 
conn.ConnectionString = @"Data Source=.\SQLExpress;" 
    +"User Instance=true;" + "Integrated Security=true;" 
    + "AttachDbFilename=|DataDirectory|GCdatabase.mdf;"; 
conn.Open(); 
//... 
conn.Close(); 

这是正确的？

如果是，那么我该如何将数据添加到表中？

Answer 1

有几种方法可以做到这一点。其中之一是使用SqlCommand对象与insert SQL语句：

SqlConnection conn = new SqlConnection(); 
conn.ConnectionString(/* your connection string goes here */); 
conn.Open(); 
SqlCommand cmd = new SqlCommand("insert into table values (1, 2, 3)", conn); 
cmd.ExecuteNonQuery(); 
conn.Close(); 

Answer 2

 string connstring = @"Data Source=.\SQLExpress;" + 
          "User Instance=true;" + 
          "Integrated Security=true;" + 
          "AttachDbFilename=|DataDirectory|GCdatabase.mdf;"; 
     string insertSql = "INSERT INTO Table " + 
          "(Column1, Column2) VALUES " + 
          "(@Column2, @Column2); SELECT @@identity;"; 

     using (SqlConnection connection = 
       new SqlConnection(connstring)) 
     { 
      SqlCommand command = connection.CreateCommand(); 
      command.CommandText = insertSql; 

      command.Parameters.Add(new SqlParameter("@Column1", Column1)); 
      command.Parameters.Add(new SqlParameter("@Column2", Column2)); 

      connection.Open(); 

      command.ExecuteNonQuery(); 
     }