Acess添加记录
System.Data.OleDb;//導(dǎo)入名空間private Button1_Click(object sender,System.EventArgs e)
{if(TextBox1.Text.ToString().Trim()!=""||TextBox1.Text.ToString().Trim()!=String.Empty()){OleDbConnection con=new OleDbConnection(你的數(shù)據(jù)庫連接);//sql語句,往里insert, .... string insertsql="INSERT INTO table_name(column_name) Values(@insert_value)";con.Open();OleDbCommand cmd=new OleDbCommand(insertsql,con);cmd.Parameters.Add("@insert_value",OleDbType.Char,20).Value=TextBox1.Text.ToString().Trim();cmd.ExceuteNonQuery();con.Close();}
}
?
轉(zhuǎn)載于:https://www.cnblogs.com/leebokeyuan/p/5586700.html
總結(jié)
- 上一篇: 如何在ChemDraw中打出符号π
- 下一篇: ActiveMQ持久化方式(转)