如何接收sql语句执行（select count(*)....）的返回值

Question

http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlcommand.executenonquery.aspx

Answer 1

读取数据集的字段都不会吗，如果没有字段名，可以按索引读取，你看看msdn基本的知识也能明白

Answer 2

 SqlCommand command = new SqlCommand(sqls, dbh.conn);
             dbh.OpenConnection();
             int scount = command.ExecuteNonQuery();
             dbh.CloseConnection(); 查询结果是-1？？

Answer 3

 SqlCommand command = new SqlCommand(sqls, dbh.conn);
             dbh.OpenConnection();
             int scount = command.ExecuteNonQuery();
             dbh.CloseConnection(); 查询结果是-1？？
ExecuteScalar()

Answer 4

  public Object ExecuteScalar(string sql, string[] paraName,object[] paraValue, CommandType commandType)
        {
            using (DbCommand command = CreateDbCommand(sql, paraName,paraValue, commandType))
            {
                command.Connection.Open();
                object result = command.ExecuteScalar();
                conn.Close();
                return result;
            }
        }

Answer 5

不可能啊 随便搜索ado.net都有了.1年没写代码 也不至于吧...