★GridView排序！★
CSDN - 技术社区 - 问题
推荐给朋友 | 关闭窗口



主 题： ★GridView排序！★
作 者： hs1983 ()
等 级：
信 誉 分： 100
人 气： 5
所属社区： .NET技术 ASP.NET
问题点数： 20
回复次数： 0
发表时间： 2007-7-4 10:22:56



我怎按字段名手排序？？！些！了!
定部分：
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text != " " && TextBox2.Text != " ")
{
SqlConnection Sqlcon = new SqlConnection(SqlconString.SqlconnectionString);

string strsql = "SELECT SFCYMJ.MJ011, SFCYML.ML005, SFCYML.ML006, SFCYML.ML015, SFCYMK.MK033, BCDMK.MK003, SFCYML.ML046, INVMB.MB002, SUM(SFCYMK.MK017) AS Expr1, SUM(SFCYML.ML016) AS Expr2 FROM BCDMK INNER JOIN SFCYMJ INNER JOIN SFCYML ON SFCYMJ.MJ001 = SFCYML.ML001 AND SFCYML.ML001 = '5172 ' AND SFCYMJ.MJ002 = SFCYML.ML002 INNER JOIN SFCYMK ON SFCYMJ.MJ001 = SFCYMK.MK001 AND SFCYMK.MK007 = 'A ' AND SFCYMJ.MJ002 = SFCYMK.MK002 AND SFCYML.ML003 = SFCYMK.MK003 INNER JOIN INVMB ON SFCYML.ML015 = INVMB.MB001 ON BCDMK.MK001 = SFCYML.ML015 ";
strsql += " Where SFCYMJ.MJ004 > = ' "+this.TextBox1.Text.ToString().Trim() + " ' ";

strsql += " and SFCYMJ.MJ004 <= ' " + this.TextBox2.Text.ToString().Trim() + " ' GROUP BY SFCYML.ML005, SFCYML.ML006, SFCYML.ML015, SFCYMK.MK033, INVMB.MB002, BCDMK.MK003, SFCYML.ML046,SFCYMJ.MJ011 ";
SqlCommand cmd = new SqlCommand(strsql, Sqlcon);
SqlDataAdapter sda = new SqlDataAdapter(strsql, Sqlcon);
DataSet ds = new DataSet();
sda.Fill(ds, "SFCYML ");
GridView1.DataSource = ds.Tables[ "SFCYML "];
GridView1.DataBind();
}
else
{

Response.Write( " <script> alert( '您起止日期! ') </script> ");
}
}


[解决办法]
一个 很简单的问题 : 一是 内容太杂..而是 发错了地方
所以没有人帮你回答 ..

DataSet ds = new DataSet();
sda.Fill(ds, "SFCYML ");
GridView1.DataSource = ds.Tables[ "SFCYML "];
GridView1.DataBind();
================================
DataView dv=ds.Tables[0].DefaultView;

dv.Sort= " 字段 desc "; 降序 当要对多个列排序的时候,用 " , "
默认升序
GridView1.DataSource = dv;
GridView1.DataBind();

[解决办法]

GridView1.AllowSorting= "True "
[解决办法]
为什么不用存储过程呢？