19,502
社区成员
发帖
与我相关
我的任务
分享
//实列化连接对象
SqlCeConnection con = new SqlCeConnection(strCon);
if (con.State == ConnectionState.Closed || con.State == ConnectionState.Broken)
{
con.Open();
}
try
{
//实列化命令对象
SqlCeCommand cmd = new SqlCeCommand(sql, con);
if (pars != null && pars.Length > 0)
{
foreach (SqlCeParameter p in pars)
{
cmd.Parameters.Add(p);
}
}
cmd.CommandType = type;
//执行插入,修改,删除操作
int count = cmd.ExecuteNonQuery();
return count;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}