一个简单的demo,SQL帮助类见:
C# 之SqlServer帮助类(SQLHelper),可以直接调用
string sqlCon = "server=.;uid=sa;pwd=sa;database=AssociationsManagementDb";
MySQLHelper.connectionString = sqlCon;
try
{
string insertSql = @"INSERT INTO AssociationsManagement.t_Department (name, Remark,ParentId,CreationTime,IsDeleted)
VALUES (@name, @Remark,@ParentId,@CreationTime,@IsDeleted) ;";
SqlParameter[] sqlParameter = new SqlParameter[]
{
new SqlParameter("@name","生活部4"),
new SqlParameter("@Remark","生活部生活部4"),
new SqlParameter("@ParentId","0"),
new SqlParameter("@CreationTime",DateTime.Now),
new SqlParameter("@IsDeleted","0")
};
int i = MySQLHelper.ExecteNonQuery(CommandType.Text, insertSql, sqlParameter);//使用SQL帮助类进行数据库操作
Console.WriteLine($"{i}");
Console.ReadLine();
}
catch (Exception x)
{
var str = x;
throw;
}