private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//颜色交替
e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='#fff7ce'");
if(e.Item.ItemType == ListItemType.Item)
{
e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='#ffffff'");
}
if(e.Item.ItemType ==ListItemType.AlternatingItem)
{
e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='seashell'");
}
}
}
删除确认:right click DataGrid1-->“属性生成器”-->添加“删除”按纽列-->在“文本(T)"中写
<div id="del" οnclick="JavaScript:return confirm('确定删除吗?')">删除</div>
添加删除事件
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName == "Delete")
{
int index = Int32.Parse(DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
DeleteRecord(index);
GetAllAssets();//重新绑定数据
}
}
添加一个递增的数字列:
<asp:BoundColumn DataField="RowNumber" HeaderText="序号"></asp:BoundColumn>
在加载数据时添加创建递增列:
/// <summary>
/// 加载数据,绑定到DataGrid
/// </summary>
private void LoadData()
{
string strCmd = "";
if(Session["sorting"] == null)
{
strCmd = "SELECT * FROM Jxt_DeviceManage_DeviceBasicData";
}
else
{
strCmd = "SELECT * FROM Jxt_DeviceManage_DeviceBasicData ORDER BY "+Session["sorting"].ToString()+" "+Session["sortDirection"].ToString();
}
conn = new SqlConnection(strConn);
adapter = new SqlDataAdapter(strCmd,conn);
ds = new DataSet();
adapter.Fill(ds);
DataTable dt = ds.Tables[0];
DataColumn dataCol = new DataColumn("RowNumber",Type.GetType("System.Int16"));
dt.Columns.Add(dataCol);
for(int i=0;i<dt.Rows.Count;i++)
{
if(0 == i)
{
dt.Rows[i][dataCol] = 1;
}
else
{
dt.Rows[i][dataCol] = Convert.ToInt16(dt.Rows[i-1][dataCol])+1;
}
}
DataView dv = new DataView(dt);
DataGrid1.DataSource = dv;
DataGrid1.DataKeyField = "DBID";
this.DataGrid1.DataBind();
if(this.DataGrid1.Items.Count < 1)
{
this.DataGrid1.Visible = false;
Response.Write("没有任何设备");
}
}