没看懂啊,我的是这样的,先查询数据库里的字段 string s_Sql = "select w.wareID,w.wareName,w.Grade,(select wareName+'.'+specification+'.'+Grade from dbo.ware)specification,(select unitname from unitab where unitid=w.unitid)unitname,u.unitID,w.producer,w.packaging,w.brand from dbo.ware w left join dbo.unitab u on w.unitID=u.unitID";//语句可能插入有错误 showlsvDealing(s_Sql); 然后再像这样在listview里显示出来 private void showlsvDealing(stringstrSQL) { this.lsvOffice.Items.Clear(); DataTable myDT = DBOperation.DBOperate.GetDataTableBySql(strSQL); for (int i = 0; i < myDT.Rows.Count; i++) { ListViewItem li = new ListViewItem(); li.SubItems.Clear(); li.SubItems[0].Text = myDT.Rows[i]["wareID"].ToString();//商品编码 li.SubItems.Add(myDT.Rows[i]["wareName"].ToString());//商品名称 li.SubItems.Add(myDT.Rows[i]["Grade"].ToString());//商品型号 ............. }就是这样显示,但是代码不会写啊
//假设 List<T> dataSource 是从数据库中读取出来的是该数据的描述类,T中包含TempItem列且该列是需要修改的
//ListView dataView 是显示控件
//using System.Linq;
protected string HandleString(object o)
{
return "徐工米色底漆 .GL12-1400.20KG"; //o.ToString();//这里修改字符串
}
override OnInit(EventArgs e)
{
//已省略取数据的步骤
dataView.DataSource=dataSource.Select(x=>{
new {
TempItem=HandleString( x.TempItem)//处理字符串;
}});
dataView.DataBind();
}
//T是该数据的描述类
//T中包含TempItem列且该列是需要修改的列
string s_Sql = "select w.wareID,w.wareName,w.Grade,(select wareName+'.'+specification+'.'+Grade from dbo.ware)specification,(select unitname from unitab where unitid=w.unitid)unitname,u.unitID,w.producer,w.packaging,w.brand from dbo.ware w left join dbo.unitab u on w.unitID=u.unitID";//语句可能插入有错误
showlsvDealing(s_Sql);
然后再像这样在listview里显示出来
private void showlsvDealing(stringstrSQL)
{ this.lsvOffice.Items.Clear(); DataTable myDT = DBOperation.DBOperate.GetDataTableBySql(strSQL);
for (int i = 0; i < myDT.Rows.Count; i++)
{
ListViewItem li = new ListViewItem();
li.SubItems.Clear(); li.SubItems[0].Text = myDT.Rows[i]["wareID"].ToString();//商品编码 li.SubItems.Add(myDT.Rows[i]["wareName"].ToString());//商品名称 li.SubItems.Add(myDT.Rows[i]["Grade"].ToString());//商品型号
.............
}就是这样显示,但是代码不会写啊