在数据库中插入列表

本文关键字：插入列列表插入数据库 | 更新日期: 2023-09-27 18:19:03

我有一个列表在richtextbox ex:

dogs
cats 
books
other

如何插入表"动物"，列"家"一行?

在数据库中插入列表

使用ODBC:

string connectionString ="yourConnectionString"
using (DbConnection conn = new OdbcConnection(connectionString))
using (DbCommand cmd = conn.CreateCommand())
{
  cmd.CommandText = "INSERT INTO Animals(home) VALUES (@animal)";
  DbParameter p = cmd.CreateParameter();
  p.ParameterName = "@animal";
  cmd.CommandType = CommandType.Text;
  conn.Open();
  using (DbTransaction tran = conn.BeginTransaction())
 {
     cmd.Transaction = tran;
     try
     {
         foreach (string line in MyRichTextBox.Lines)
         {
            p.Value = line;
            cmd.ExecuteNonQuery();
         }
         tran.Commit();
         conn.Close();
     }
     catch (Exception e)
     {
         tran.Rollback();
        throw(e);
     }
 }

}