如何去掉下图中得分单位里的重复项,变为这个样子的,先谢谢了
解决方案 »
- windows 服务 内存管理
- 学习javascript jquery 还有必要学prototype框架么
- repeater控件上部会生成很多空行,请问如何解决
- asp.net 中 keybd_event
- 求visual studio .net 2005的英文版下载地址?
- 领航菜单变色的实现
- GridView可以动态绑定多个表字段吗
- 通过<input type=file>读取word乱码的问题 (在线等)
- 用Enterprise Library生成的名字的问题
- 关于DataGrid的问题 如何使一列隐藏(急!!谢谢了!!)
- 求问:VS 2002 安装出错
- GridView Dispose()问题
http://www.cnblogs.com/arp_net/archive/2010/09/03/1816836.html
关键字:distinct
select distinct(name),age,score from student
晕,不怕麻烦啊,那么多没用的数据提出来干嘛,而且提出来之后还是要去掉
在sql里写多舒服呢
Google查sql 行转列
private DataTable dt;
protected void Page_Load(object sender, EventArgs e)
{
dt = new DataTable();
DataColumn dc1 = new DataColumn("列1", typeof(string));
DataColumn dc2 = new DataColumn("列2", typeof(int));
DataColumn dc3 = new DataColumn("列3", typeof(int));
dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
dt.Columns.Add(dc3);
dt.Rows.Add("三分厂", 44, null);
dt.Rows.Add("二分厂", 60, null);
dt.Rows.Add("三分厂", null, 80);
dt.Rows.Add("二分厂", null, 90);
dt.Rows.Add("一分厂", null, 80);
dt.Rows.Add("二分厂", null, 90);
dt.Rows.Add("一分厂", 20, 30);
dt.Rows.Add("一分厂", 20, null);
dt.Rows.Add("四分厂", 120, null);
GridView1.DataSource = dt;
GridView1.DataBind();
} /// <summary>
/// 处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
DataTable newDt = dt.Clone();
List<string> nameList = new List<string>();
foreach (DataRow row in dt.Rows)
{
if (!nameList.Contains(row[0].ToString()))
{
nameList.Add(row[0].ToString());
DataRow newRow = newDt.NewRow();
newRow["列1"] = row[0].ToString();
newRow["列2"] = 0;
newRow["列3"] = 0;
newDt.Rows.Add(newRow);
}
} foreach (DataRow newRow in newDt.Rows)
{
foreach (DataRow row in dt.Rows)
{
if (row["列1"].ToString() == newRow["列1"].ToString())
{
if (row["列2"] == DBNull.Value)
row["列2"] = 0;
if (row["列3"] == DBNull.Value)
row["列3"] = 0;
newRow["列2"] = Convert.ToInt32(newRow["列2"]) + Convert.ToInt32(row["列2"]);
newRow["列3"] = Convert.ToInt32(newRow["列3"]) + Convert.ToInt32(row["列3"]);
}
}
}
GridView1.DataSource = newDt;
GridView1.DataBind();
}
select * from
(
select rowNum=Row_Number() over(partition by 得分单位 order by 得分单位),得分单位,重型二分厂
from 表名
) tb where tb.rowNum=1
select distinct name from [uTable] where....