Example #1
0
        public DataTable SelectAll(string query)
        {
            da = new SqlDataAdapter(query, ProductDAL.connect());
            DataTable dt = new DataTable();

            da.Fill(dt);
            return(dt);
        }
Example #2
0
        public bool DMLOpperation(string query)
        {
            cmd = new SqlCommand(query, ProductDAL.connect());
            int x = cmd.ExecuteNonQuery();

            if (x == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }