I am using ASP.net ,C#
I have a table "MAINTABLE" i m retiieving some fields from table i am using ODbc .
I want to display those fields in tables .I am using datareader .
i want to show them fields in table ( for every row generate a new table )
name :
Father NAme :
Adress
Phone NUmber

Can any one help me out .
?
Thanks in Advance.

hmmm, why not just bind the entire result set to a datagrid?? You could do something like this:

private void someMethod(){
string sqlcmd = "SELECT [data] FROM [table]";
DataTable dt = new DataTable();
dt = getDataTable();
datagrid.DataSource = dt;
datagrid.DataBind();
}

        private DataTable getDataTable(string sqlcmd)
        {
            DataTable dt = new DataTable();
            sqlConn = new SqlConnection([connection string]);
            cmd = new SqlCommand(sqlcmd, sqlConn);
            daSql = new SqlDataAdapter(sqlcmd, sqlConn);
            daSql.Fill(dt);

            return dt;
        }

where daSql = DataAdapter
cmd = SqlCommand
sqlConn = SqlConnection

hth

"The one language all programmers understand is profanity."

Thanks.
         I willl try this.

IT is working but not meet to my requirements i want each result set in a seperate table

What you can do is create a table in code for each row returned to the datatable something like this:

foreach(DataRow dr in dt.Rows){
   Table tbl = new Table();
   TableRow tr = new TableRow();
   TableCell tc = new TableCell();

   /*you can add styles to the rows/cells/table by calling
    *the various properties of any of the objects
    */

   tr.cells.add(tc);
   tbl.rows.add(tr);
   pnlTable.Controls.Add(tbl);
}

This assumes that there is a panel on your webform named pnlTable and you will actually have to set up the data that goes into the tables but this will give you a table for each record.

"The one language all programmers understand is profanity."

thanks for reply. iwill check it out.