How to Display data from database on tabular format ?

Shahbaz Kaware

B2B		Q1, 2018	Q2, 2018	Q3, 2018	Q4, 2018	TOTAL - 2018
contract 1	Policies Issued
contract 1	Premium
contract 2	Policies Issued
contract 2	Premium
contract 3	Policies Issued
contract 3	Premium
contract 4	Policies Issued
contract 4	Premium
contract 5	Policies Issued
contract 5	Premium
contract 6	Policies Issued
contract 6	Premium
contract 7	Policies Issued
contract 7	Premium
contract 8	Policies Issued
contract 8	Premium
contract 9	Policies Issued
contract 9	Premium

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Jain6y ago
Hello,

To display database data in table format then you can use Repeater control (https://www.c-sharpcorner.com/UploadFile/5089e0/how-to-use-repeater-control-in-Asp-Net/) for a custom design or you can use GridView Control (https://www.c-sharpcorner.com/UploadFile/7eb164/gridview-control-in-Asp-Net/) directly to display in tabular format.

Thanks
Sujay Anand6y ago
Hi Please refer this code for reference
public string getWhileLoopData()
{
SqlConnection conn = new SqlConnection();
conn.Open();
SqlCommand cmd= new SqlCommand("SELECT * from Test");
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string Name = reader.GetString(1);
string Pass = reader.GetString(2);
htmlStr +=""+id+""+Name+""+Pass+""
}
conn .Close();
return htmlStr;
}
Chittaranjan Swain6y ago
Hi,

Refer below links,

https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/
https://www.aspforums.net/Threads/160348/Display-data-from-database-in-HTML-Table-format-using-C-and-VBNet-in-ASPNet/
https://www.aspsnippets.com/Articles/Display-data-from-database-in-HTML-table-in-ASPNet.aspx
Salman Beg6y ago
Follow this link, https://www.aspsnippets.com/Articles/Display-data-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx
Shahbaz Kaware6y ago
Which article can u plz help me for the same
Salman Beg6y ago
If you are using gridview then you need to design it properly. Follow some articles of gridview . Thanks
Shahbaz Kaware6y ago
Im using grid view but not achived the display like the above
Salman Beg6y ago
Hi. You need to use any of the grid to display like a table. If you are using asp.net then you can use gridview etc. If you are using mvc then you can use razor html or any 3rd party grid. Thanks.