create div dynamically using database

narasiman rao

10y1.3kC#

i want to create dynamically div using database

In database record as follows
In LatestNewsMaster table record as follows

ID Subject Description Link
1 Accounts Accounts fee page Accountsfees.aspx
2 Defects Defects mail report Defects.aspx

my code as follows

string constr = ConfigurationManager.ConnectionStrings["Reception2_DB"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
sing (SqlCommand cmd = new SqlCommand("select Subject,Description,Link from LatestNewsMaster where active <> 'd'"))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
for (int i = 0; i {
lblSub.Text += dt.Rows[i][0].ToString().Trim() + "
";
lbldesc.Text += dt.rows[i][1].ToString().Trim() +"
";
llbLink.Text += dt.rows[i][2].ToString().Trim() + "
";
}
}
}

When i run the above code output as follows

Accounts (Subject Displayed from the database)
Defects (Subject Displayed from the database)
Accounts fee page (Description Displayed from the database)
Defects mail report (Description Displayed from the database)
Accountsfees.aspx (Link Displayed from the database)
Defects.aspx (Link Displayed from the database)

But i want the above ouptut to be displayed as follows

Subject Description Link
Accounts Accounts fee page Accountsfees.aspx
Defects Defects mail report Defects.aspx

2 Replies

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

Manas Mohapatra10y ago
Try with below code:

Create div in aspx page:

In code behind generate HTML content and set InnerHTML property:

StringBuilder sb = new StringBuilder();

// Looping over your DataTable which is fetched from Database
for (int i = 0; i {
   sb.Append("" + dt.Rows[i][0].ToString().Trim() + "");
   sb.Append("" + dt.Rows[i][0].ToString().Trim() + "");
   sb.Append("" + dt.Rows[i][0].ToString().Trim() + "");
}

divData.InnerHtml = "" + sb.ToString() + "
Subject Desc Link
";
Raja T10y ago
Hello Narasiman, u can manage in your query only. instead of select query use store procedure. try like

create proc sp_demo
as
begin
declare @tbl_temp as table(Subject varchar(800),Description varchar(800),Link varchar(800))
insert into @tbl_temp values ('Accounts','Accounts fee page','Accountsfees.aspx')
insert into @tbl_temp values ('Defects','Defects mail report ','Defects.aspx')
select * from @tbl_temp
end
exec sp_demo