case "del": string id = DataGrid1.DataKeys[(int)(e.Item.ItemIndex)].ToString(); string strSQL = "..."; MyClass.ExecuteQuery(strSQL);
break; } MyDataBind(); }
Private Sub grdDelete_ItemCommand(ByVal source As System.Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles grdDelete.ItemCommand 'If Session("user") <> "admin" Then ' Response.Write("<script language=javascript>alert('You have no authority to perform this task!')</script>") 'Else Dim Doctor As New BResidentDoctors Doctor.Delete(Session("ResidentID"), grdDelete.DataKeys(e.Item.ItemIndex)) BindSelect() BindDelete() Response.Redirect("doctor.aspx") 'End If End Sub
实现修改功能,在Datagrid中加入超级连接列,在定义所要连接的页面和所需传递的参数。你的修改功能就可以在这个页面中实现。
{
string strId = e.Item.Cells[1].Text;
Response.Write(strId);
}
{
LinkButton lbtdelete = e.Item.FindControl("lbtdelete") as LinkButton;
if (lbtdelete!=null)
{
lbtdelete.Attributes.Add("onclick","var d = '您确定要报废该车辆吗?';return window.confirm(d);");
}
} private void dtgtruck_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int ID = System.Convert.ToInt32(e.Item.Cells[0].Text);
string strtruck;
strtruck="SELECT * FROM USER_TRUCK WHERE UT_ID="+ID+"";
DataSet dstruck=new DataSet();
dstruck=Info.Select(strtruck,"USER_TRUCK");
if(dstruck.Tables["USER_TRUCK"].Rows[0]["UT_STATUS"].ToString()!="1")
{
string strSql;
strSql="INSERT INTO USER_SCRAP(US_USER,US_CODE,US_IN_DATE,US_DATE,US_STATUS) VALUES ("+Session["USER_ID"]+",'"+dstruck.Tables["USER_TRUCK"].Rows[0]["UT_CODE"].ToString().Replace("'","''").ToString()+"','"+ dstruck.Tables["USER_TRUCK"].Rows[0]["UT_DATE"].ToString() +"','"+System.DateTime.Now.ToString()+"',"+0+" )";
// Response.Write(strSql);
// Response.End();
Info.Modify(strSql);
string str;
str= "DELETE USER_TRUCK WHERE UT_ID="+ ID +"";
Info.Modify(str);
Log.AddLog(System.Convert.ToInt32(Session["USER_ID"]),"报废车辆","报废车辆成功",Request.UserHostAddress.ToString());
Response.Redirect("MagStudentViewTruck.aspx?tag=2");
}
else
{
Response.Write("<script>window.alert('此车辆正在出车中,无法报废!')</script>");
}
}
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{ string MyComm = e.CommandName.ToString();
switch(MyComm)
{
case "del": string id = DataGrid1.DataKeys[(int)(e.Item.ItemIndex)].ToString();
string strSQL = "...";
MyClass.ExecuteQuery(strSQL);
break;
}
MyDataBind();
}
'If Session("user") <> "admin" Then
' Response.Write("<script language=javascript>alert('You have no authority to perform this task!')</script>")
'Else
Dim Doctor As New BResidentDoctors
Doctor.Delete(Session("ResidentID"), grdDelete.DataKeys(e.Item.ItemIndex)) BindSelect()
BindDelete()
Response.Redirect("doctor.aspx")
'End If
End Sub
Width="100%" BorderColor="Tan" BorderWidth="1px" DataKeyField="doctorid" AutoGenerateColumns="False">
<AlternatingItemStyle BackColor="#FFE0C0"></AlternatingItemStyle>
<HeaderStyle Font-Bold="True" Height="20px" ForeColor="Tan" BackColor="Maroon"></HeaderStyle>
<Columns>
<asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete"></asp:ButtonColumn>
<asp:BoundColumn DataField="Type" HeaderText="Doctor Type"></asp:BoundColumn>
<asp:BoundColumn DataField="Name" HeaderText="Name"></asp:BoundColumn>
<asp:BoundColumn DataField="flag" HeaderText="Primary Doctor"></asp:BoundColumn>
<asp:BoundColumn DataField="DrProviderNo" HeaderText="Provider No"></asp:BoundColumn>
<asp:BoundColumn DataField="DrPhone" HeaderText="Phone"></asp:BoundColumn>
<asp:BoundColumn DataField="DrEmail" HeaderText="Email"></asp:BoundColumn>
</Columns>
</asp:datagrid>