Best thing to put data from a databse into

Hey all, i am writing a webpage that retrieves data from a database in the form of an OracleDataReader.

Now it returns a couple of ids and some names. What i want to do is to insert the names into the first columns in a table on the webpage.

Then use the ids it has grabbed to execute another query to retrieve more data and then place that data into the same table as before.

What i need to know is would a table be the best thing to use. And how can i manually input text into each of the cells in the table / or gridview / or repeater

Comments

  • : Hey all, i am writing a webpage that retrieves data from a database
    : in the form of an OracleDataReader.
    :
    : Now it returns a couple of ids and some names. What i want to do is
    : to insert the names into the first columns in a table on the
    : webpage.
    :
    : Then use the ids it has grabbed to execute another query to retrieve
    : more data and then place that data into the same table as before.
    :
    : What i need to know is would a table be the best thing to use. And
    : how can i manually input text into each of the cells in the table /
    : or gridview / or repeater


    Hello, you can read all the data from the db at once. Do you know SQL well, you could write join SQL to call the data out of db at once. Once done, you can bind the data to any server controls such as Repeater, DataList or DataGrid etc on the web page.

    Hope this gives you the general idea and could be of some help to you.



    I'm Brad Wang...
    .NET Freelancer from China
    MSN: [email protected]
    Skype: brad_wang
  • seancampbellseancampbell Pennsylvania, USA
    : Hey all, i am writing a webpage that retrieves data from a database
    : in the form of an OracleDataReader.
    :
    : Now it returns a couple of ids and some names. What i want to do is
    : to insert the names into the first columns in a table on the
    : webpage.
    :
    : Then use the ids it has grabbed to execute another query to retrieve
    : more data and then place that data into the same table as before.
    :
    : What i need to know is would a table be the best thing to use. And
    : how can i manually input text into each of the cells in the table /
    : or gridview / or repeater

    To me it sounds like your on the right track. I would try posting this on ASP.Net page as this is more of a web question.

    I have done a lot of SQL Server DB work with Asp.Net web apps (using VB.Net as my code behind). I have not figured out a non-complicated way to provide entry fields for any cell in a gridview to allow managing a DB with a web app.. but I am sure it is do able.

    Go look for some more information about the GridView, it is a quite powerful tool.

    -Firesickle.com
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories