C# (CSharp) OpenDB.SELECT Examples

Example #1

        public DataTable getplace()
        {
            List <IDbDataParameter> SetParameters = new List <IDbDataParameter>();
            string SQLString = "";

            SQLString = "SELECT  * FROM item_place";

            return(iOpneDB.SELECT(SQLString, SetParameters));
        }

Example #2

        public DataTable getitem(string place)
        {
            OpenDB iOpneDB = new OpenDB();



            List <IDbDataParameter> SetParameters = new List <IDbDataParameter>();
            string SQLString = "";

            SQLString = "SELECT  * FROM item_withplace where item_place = @Itemplace";

            SetParameters.Add(new SqlParameter("@Itemplace", place));


            return(iOpneDB.SELECT(SQLString, SetParameters));
        }