我用datagrid做了个表,
但必须有删除功能,
所以我加了<asp:ButtonColumn Text="删除" CommandName="delete"/>可他怎么实现其功能呀
sub DataGrid1_DeleteCommand(obj as object, e as DataGridCommandEventArgs)
' delete from data store
DataGrid1.DataBind()
end sub
里面怎么写呀,
最简单的就行,不知道有没有默认的,
但必须有删除功能,
所以我加了<asp:ButtonColumn Text="删除" CommandName="delete"/>可他怎么实现其功能呀
sub DataGrid1_DeleteCommand(obj as object, e as DataGridCommandEventArgs)
' delete from data store
DataGrid1.DataBind()
end sub
里面怎么写呀,
最简单的就行,不知道有没有默认的,
解决方案 »
- 关于参数化查询。两段语句,前辈们指点下。
- repeater的翻页问题请教,急?
- 我用hashtable和Session做的购物车会员登陆后点击提交后如何把购物车的数据插入订单表??
- 母版页不能用无刷回调功能?
- 怎么设置服务器,使得asp.net能够上传文件
- 求救啊,为什么我的老是出问题啊!(100)
- 求助:EVENTTARGET 的问题
- 关于上传文件的问题
- 关于asp.net如何捕获键盘事件
- 用VS.NET开发三层结构的ASP.NET程序的问题
- 经常会出现“未将对象引用设置到对象实例”的对话框,不知道是什么问题
- 难题:请教MeasureString时webcontrols与Drawing的字体问题
然后在
<asp:ButtonColumn Text="删除" ButtonType="PushButton" CommandName="Delete">
<asp:ButtonColumn Text="阅读" ButtonType="PushButton" CommandName="Read">后台里加入如下代码:
public void DG_ItemCommand(Object sender,DataGridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
//add delete code here
}
else if (e.CommandName == "Read")
{
//add read code here
}
}
哪个代表直呀。我不会写呀
cmd.ExecuteNonQuery()
那不全删了吗?
怎么
delete from guest where id=?
那个问号是哪个直呀
String strSql= "delete from 表名 where 主键名= '"+DataGrid1.DataKeys[(int)e.Item.ItemIndex]+"'";
dim sql1 as string
Sql1="delete from guest where id='"&DataGrid1.DataKeys[(int)e.Item.ItemIndex]&"'"; DataGrid1.DataBind()
我这样写可以吗?
allenchao(magci_轮)
我给你加分。
dim sql1 as string
Sql1="delete from guest where id='"&DataGrid1.DataKeys[(int)e.Item.ItemIndex]&"'"; DataGrid1.DataBind()
我这样写可以吗?
allenchao(magci_轮)
我给你加分。
sub DataGrid1_DeleteCommand(obj as object, e as DataGridCommandEventArgs)
dim sql1 as string
Sql1="delete from guest where id='"&DataGrid1.DataKeys[(int)e.Item.ItemIndex]&"'"
cmd.ExecuteNonQuery()
DataGrid1.DataBind()
end sub
这样写哪错了,指点呀
private void c1FlexGrid1_Click(object sender, System.EventArgs e)//CLICK事件
{
if(this.c1FlexGrid1.Row!=-1)//防止c1FlexGrid1为空的时候抱错单击的时候
{
xx = this.c1FlexGrid1[c1FlexGrid1.Row,"id"].ToString();//获取c1FlexGrid1里的ID值
F8Dll.ClearText(this,true); //这是自己写的控件,里面的清空功能。可以不用
F8Dll.ShowData(this,"select * from biao1 where id ='"+xx+"'",""); //这也是我自己的控件里面的功能,用来在TEXTBOX里面显示你CLICK的相应信息。。可以不用
}
private void button2_Click(object sender, System.EventArgs e)//删除事件
{
if(MessageBox.Show("你真的要删除这条记录吗?","易可思提示!",MessageBoxButtons.OKCancel,MessageBoxIcon.Question)==DialogResult.OK)
{
App.ExecSql("delete from biao1 where id='"+xx+"'");//xx就是获取的ID值用来删除,这也是我控件里面的功能,但是你只要知道意思就可以,功能就是这样的实现的。
Chazhao();//这是我写的方法可以不用。
F8Dll.ClearText(this,true);//不用解释了吧。
}
}
}
}
我这是举用ComponentOne里的c1FlexGrid1来显示数据,不是用DataGrid。后面有解释
cmd.ExecuteNonQuery()
DataGrid1.DataBind()
----------------
没有执行sql1啊!!!
首先在asp页面的html 代码前面加入如下代码:
<script language="JavaScript">
function delete_confirm(e)
{
if(event.srcElement.outerText == "×")
event.returnValue=confirm("确认删除否?");
}
document.onclick=delete_confirm;
</script>
然后就在datagrid加一个属性和一列
<asp:datagrid .....OnDeleteCommand="DeleteBtn_Click"....../><asp:ButtonColumn HeaderText="删" Text="×" CommandName="Delete" ItemStyle-Font-Size="smaller" ItemStyle-Width="3%"></asp:ButtonColumn>最后就在后台代码编写DeleteBtn_Click事件函数就可以啦
然后在
<asp:ButtonColumn Text="删除" ButtonType="PushButton" CommandName="Delete">
<asp:ButtonColumn Text="阅读" ButtonType="PushButton" CommandName="Read">后台里加入如下代码:
public void DG_ItemCommand(Object sender,DataGridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
//add delete code here
DelField(e.Item.Cells [0].Text.Trim ()); //删除字段 //这里e.Item.Cells [0].Text.Trim ()对应的是你在DG中定义的数据列,
//根据什么关键字来删除自己调整
}
else if (e.CommandName == "Read")
{
//add read code here
}
}#region 删除指定字段(里面的数据库对象假设都是定义和初始化好的了,我不在定义了)
public void DelField(string id)
{
string sqlstr="Delete From DataTable Where FieldName='" + id + "'";//DataTable就是你要删除字段的表名
//FieldName就是字段名
//id是值try
{
cmd=new SqlCommand (sqlstr,myConn);
cmd.Connection.Open ();
cmd.ExecuteNonQuery ();
}
catch{}
finally
{
cmd.Connection.Close ();
}
}
#endregion
dim i as String = CType(e.Item.FindControl("lblID"), Label).Text
Response.write (i)
DeleteRecord(i) 'Call Sub
MyDataGrid.EditItemIndex = -1
Try
BindGrid()
Catch
MyDataGrid.CurrentPageIndex = MyDataGrid.PageCount - 1
BindGrid()
End Try
End Sub Sub DeleteRecord(DelRecord)
Dim MyCommandDel As OleDbCommand
Dim InsertCmd As String = "DELETE FROM board WHERE boardid = @Id"
MyCommandDel = New OleDbCommand(InsertCmd, myConnection)
MyCommandDel.parameters.add("@id",DelRecord)
MyCommandDel.Connection.Open()
MyCommandDel.ExecuteNonQuery()
MyCommandDel.Connection.Close()
End Sub
<asp:ButtonColumn Text="阅读" ButtonType="PushButton" CommandName="Read">后台里加入如下代码:
public void DG_ItemCommand(Object sender,DataGridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
//add delete code here
DelField(e.Item.Cells [0].Text.Trim ()); //删除字段 //这里e.Item.Cells [0].Text.Trim ()对应的是你在DG中定义的数据列,
//根据什么关键字来删除自己调整
}
else if (e.CommandName == "Read")
{
//add read code here
}
}#region 删除指定字段(里面的数据库对象假设都是定义和初始化好的了,我不在定义了)
public void DelField(string id)
{
string sqlstr="Delete From DataTable Where FieldName='" + id + "'";//DataTable就是你要删除字段的表名
//FieldName就是字段名
//id是值try
{
cmd=new SqlCommand (sqlstr,myConn);
cmd.Connection.Open ();
cmd.ExecuteNonQuery ();
}
catch{}
finally
{
cmd.Connection.Close ();
}
}
#endregion