i want to change the output from coumns to rowsusing string

narasiman rao

i want to change the output from columns to rows using string builder in asp.net

My code as follows

System.Text.StringBuilder sbNews = new System.Text.StringBuilder();
string myConString = ConfigurationManager.ConnectionStrings["Reception2_DB"].ConnectionString;

using (SqlConnection conn = new SqlConnection(myConString))
{
string query;
query = Select Subject,Description,Link,Entereddate from LatestNewsMaster and active <>'d'";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
sbNews.Append(rdr[3].ToString() + "
");
sbNews.Append(rdr[0].ToString() + "
");
sbNews.Append(rdr[1].ToString() + "
");
sbNews.Append(rdr[2].ToString() + "
");

}
}
NewsTicker = sbNews.ToString();
}

In database record as follows

Subject Description Link entereddate
Defects Defects page Defects.aspx 22Dec2015
Accounts Accounts Page Accounts.aspx 29Dec2015

When i run the above code output as follows

22Dec2015
Defects
Defects page
Defects.aspx

22Dec2015
Accounts
Accounts Page
Accounts.aspx

But i want the output as follows in the run mode as follows

22Dec2015 Defects Defects page Defects.aspx
22Dec2015 Accounts Accounts page Accounts.aspx

for that how can i do in asp.net using c#.

3 Replies

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

Akhil Garg10y ago
you can use string instead of stringbuilder and dont need to append one by one. Try this.

sbNews =rdr[3].ToString() + " " +rdr[0].ToString() + " " +rdr[1].ToString() + " "+rdr[2].ToString() ;
Rajeev Punhani10y ago
Hi Narasiman,

Please find the below link
http://techclubdotnet.blogspot.in/2015/07/convert-gridview-rows-to-column.html

Transpose method in this link can be used to achieve same result.
Raja T10y ago
Hi, Please refer below URLs

http://mobile.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html

http://blog.devart.com/is-unpivot-the-best-way-for-converting-columns-into-rows.html

http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql