Getting the first row? RRS feed

  • Question

  • I would like to get the first row of a returned DataSet. I picture my command and query something like:

    command.CommandText =

    string.Format("SELECT * FROM [{0}UpdateVariantStagingTable]", this._partner.Name);

    command.CommandType =


    I would like to have a DataRow returned. I know I can execute a SqlDataReader with this command but I would like a whole row (if it exists). Any ideas?

    Thank you.

    Kevin Burton
    Tuesday, January 4, 2011 8:48 PM


All replies