asp

Question

hello  i want to retrive data from my database in form of table .i want that rows should be generted at the run time using loop and my data is displayted in form of table plz help.

Pankaj Pandey · Answer

if there is a way to fetch data into table directly then why do you want to create table at run time? Is any specific requierment?

Jignesh Trivedi · Answer

hi In this case you can use Jquery grid. Please refer http://jquerygrid.net/ http://www.jquery4u.com/plugins/10-jquery-grids/ if you are framework 4.5 user than SignalR can be help you.

Sanjeeb Lenka · Answer

you can directly get the the data from database and store the data in a dataset then bind the dataset to gridview

Alok Uniyal · Answer

HI ashima First add asp:Table control in your web page where you want to display it. Let you add a table with id tbl On pageload event do this- SqlConnection con = new SqlConnection(*/Your Connection*/); con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = Select * from Test; SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { TableRow tr = new TableRow(); while(rdr.Read()) { string rowdata = rdr[0].ToString(); TableCell tc = new TableCell(); tc.Text = rowdata; tr.Cells.Add(tc); } tbl.Rows.Add(tr); } con.Close();

ashima kukreja · Answer

i am developing a web based application

Alok Uniyal · Answer

Hi ashima You are developing a window or web application?