Acess添加记录

System.Data.OleDb;

//导入名空间

private Button1_Click(object sender,System.EventArgs e)
{
   if(TextBox1.Text.ToString().Trim()!=""||TextBox1.Text.ToString().Trim()!=String.Empty())
   {
        OleDbConnection con=new OleDbConnection(你的数据库连接);
    //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();
    }
}
本博客有部分内容来自网络,如有问题请联系:hebeilijianghua@qq.com,并注明来自博客园。
原文地址:https://www.cnblogs.com/leebokeyuan/p/5586700.html