Exemplos de DBUtility.DbHelperSQLP.Query em C# (CSharp)

Exemplo n.º 1

Arquivo: FilenameDAL.cs Projeto: wanddy/Cooperative--Office-Automation-System

        public DataTable Select(int uid, int i)
        {
            DataTable dt = sql.Query("select * from [OA_filepath] where uid=" + uid + " and isdelete=" + i + " order by Id desc").Tables[0];

            return(dt);
        }

Exemplo n.º 2

Arquivo: Pagination.cs Projeto: ericzzhou/dotnetcommon

        public static int ReCordCount(SqlCommand cmd)
        {
            string sql = "select count(*) as total " + cmd.CommandText;

            return(Convert.ToInt32(sqlhelp.Query(sql).Tables[0].Rows[0]["total"]));
        }