OleDB简单用例

最新推荐文章于 2022-02-11 17:35:01 发布

KeyRainie

最新推荐文章于 2022-02-11 17:35:01 发布

阅读量822

点赞数

分类专栏： SQL 文章标签： security insert sql string user

本文链接：https://blog.csdn.net/KeyRainie/article/details/7852354

版权

SQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

OleDbConnection connection = new OleDbConnection("Provider=Ifxoledbc.2;User ID=informix;Password=informix;Data Source=niosdb@niosserver34;Persist Security Info=true;");
string sql = "insert into tap_so_Voronoi(filename,filedata) values(':fileName', ':fileData')";
System.Data.OleDb.OleDbCommand cm = new System.Data.OleDb.OleDbCommand(sql, connection);
cm.Parameters.Add(":fileName", OleDbType.VarChar);
cm.Parameters.Add(":fileData", OleDbType.Binary);
cm.Parameters[":fileName"].Value = scan_start_time;
cm.Parameters[":fileData"].Value = fileData;
connection.Open();
cm.ExecuteNonQuery();
connection.Close();