gridview 横向显示并换行

villain2008 2009-02-10 10:18:56

用GridView绑定数据正常显示是这样的：
id name age
1 tom 25
2 jack 30
3 mary 28
4 yao 27

现在我已经可以让它横向显示了：

id 1 2 3 4
name tom jack mary Yao
age 25 30 28 27

代码如下：
SqlConnection con = new SqlConnection("Server=.;Uid=sa;DataBase=aaaaa");
string str = "Select * From bbbbb";

con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(str, con);
da.Fill(ds);

DataTable dt = ds.Tables[0];
DataTable dtNew = new DataTable();

for (int i = 0; i < dt.Rows.Count; i++)
{
dtNew.Columns.Add("Column" + i.ToString(), typeof(string));
}

foreach (DataColumn dc in dt.Columns)
{
DataRow drNew = dtNew.NewRow();

for (int i = 0; i < dt.Rows.Count; i++)
{
drNew[i] = dt.Rows[i][dc].ToString();
}
dtNew.Rows.Add(drNew);
}
this.GridView1.ShowHeader = false;
this.GridView1.DataSource = dtNew;
this.GridView1.DataBind();

我想让它显示成这样：
id 1 2
name tom jack
age 25 30

id 3 4
name mary Yao
age 28 27

请问如何实现？在线等！！！

...全文

770 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

huangdilei 2010-04-27

打赏
举报

学习了谢谢....................

小宏 2009-07-31

打赏
举报

学习了。。。。

sprc_lcl 2009-02-10

打赏
举报





        DataTable dt;

        string outhtml = "<table>";

        string outrow1model = "<tr><td>id</td>";

        string outrow2model = "<tr><td>name</td>";

        string outrow3model = "<tr><td>age</td>";

        string outrow1 = outrow1model;

        string outrow2 = outrow2model;

        string outrow3 = outrow3model;

        for (int i = 0; i < dt.Rows.Count; i++)

        {

            if (i > 0 && i % 2 == 0)

            {

                outhtml += outrow1 + "</tr>";

                outhtml += outrow2 + "</tr>";

                outhtml += outrow3 + "</tr>";

                outrow1 = outrow1model;

                outrow2 = outrow2model;

                outrow3 = outrow3model;

            }

            DataRow dr = dt.Rows[i];

            outrow1 += string.Format("<td>{0}</td>", dr["id"]);

            outrow2 += string.Format("<td>{0}</td>", dr["name"]);

            outrow3 += string.Format("<td>{0}</td>", dr["age"]);

        }

        if (dt.Rows.Count % 2 == 1)

        {

            outrow1 += "<td> </td>";

            outrow2 += "<td> </td>";

            outrow3 += "<td> </td>";

        }

        outhtml += outrow1 + "</tr>";

        outhtml += outrow2 + "</tr>";

        outhtml += outrow3 + "</tr>";



        this.Literal1.Text = outhtml;