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); } }