Ejemplos de DAO_Access AccessDBHelper.ExecuteScalar en C# (CSharp)

Ejemplo n.º 1

        public void ExecuteScalarTest()
        {
            DAO_Access.AccessDBHelper target = new DAO_Access.AccessDBHelper(); // TODO: Initialize to an appropriate value
            string sql = "select userid from users where userid=@userid";

            System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[] {
                new OleDbParameter()
                {
                    ParameterName = "userid",
                    Value         = "Payne"
                }
            };
            object expected = "Payne"; // TODO: Initialize to an appropriate value
            object actual;

            actual = target.ExecuteScalar(sql, parameters);
            Assert.AreEqual(expected, actual);
        }