1.新增一行
gvForm.DisplayLayout.Rows.Add();
2.绑定dropdownlist/textbox到webgrid中,并将数据库中的值赋给它
TemplatedColumn source = (TemplatedColumn)gvForm.Bands[0].Columns[3];
foreach (CellItem item in source.CellItems)
{
string source1 = gvForm.Rows[n].Cells.FromKey("SOURCE").Text;
DropDownList r = (DropDownList)item.FindControl("ddlsource");
//r.Items.Add(new ListItem(source1, source1));
r.Items.FindByValue(source1).Selected = true;//下拉框將值選中顯示
n++;
}
3.某个cell可编辑:
gvForm.Rows[0].Cells[1].AllowEditing = AllowEditing.Yes;//UNIT_PRICE
4.某个column可更新
gvForm.Columns.FromKey("upb").AllowUpdate = AllowUpdate.Yes;
5. 获取某行行号及Itemcommand 内容写法:
protected void gvForm_ItemCommand(object sender, UltraWebGridCommandEventArgs e)
{//delete
ImageButton image = (ImageButton)e.CommandSource;
int id = int.Parse(image.CommandArgument);
switch (image.CommandName)
{
case "D":
Bind(hlineid.Value);
break;
}
}
6.某列放dropdownlist ddl,选中值后触发SelectedIndexChanged事件使其他列绑定值:需要将该ddl 属性设置为:autopostback=true,
方法如下:
protected void Drpd_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddltrx=sender as DropDownList;
int row=((CellItem)ddltrx.NamingContainer).Cell.Row.Index;//获取该行行号
.......
}
7.使grid中的某列隱藏
gvForm.Bands[0].Columns[0].Hidden = true;
8.設置grid中某列背景及字體顏色
gvForm.Rows[i].Cells[0].Style.ForeColor = System.Drawing.Color.White;
gvForm.Rows[i].Cells[0].Style.BackColor = System.Drawing.Color.CornflowerBlue;