C# (CSharp) M_App.GetModelFromReader Exemples

Exemple #1

        public M_App Select(int ID)
        {
            string sqlStr = "select * from " + TbName + " where ID=@ID";

            SqlParameter[] cmdParams = new SqlParameter[1];
            cmdParams[0]       = new SqlParameter("@ID", SqlDbType.Int, 4);
            cmdParams[0].Value = ID;
            using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sqlStr, cmdParams))
            {
                if (reader.Read())
                {
                    return(initMod.GetModelFromReader(reader));
                }
                else
                {
                    return(null);
                }
            }
        }