public static void cessql()
{
try
{
string sql = "select * from ces";
DataSet ds = MsSqlHelper.SqlByAdo(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Console.WriteLine("sqlserver query success");
log.Info("sqlserver query success");
}
sql = "insert into ces(id,name)values(2,'测试')";
int result = MsSqlHelper.ExcuteSQL(sql);
if (result > 0)
{
Console.WriteLine("sqlserver execute success");
log.Info("sqlserver execute success");
}
}
catch (Exception ex)
{
Console.WriteLine("cessqlserver " + ex.Message);
log.Info("cessqlserver " + ex.Message);
}
}
