谁能帮帮我(DataGrid控件)！！！！！

huangbznet 2004-10-14 10:04:55

哪位高手帮我用vb.net写datagrid的编辑，更新和删除功能？？？

...全文

178 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

huangbznet 2004-10-14

打赏
举报

能不能把编辑和删除的代码写详细点啊？？？
谢谢了！！
我看了你上面的代码他没有反应的啊！！！
拜托了！！！

F9 2004-10-14

打赏
举报

主要就是在DataGrid1_DeleteCommand(删除)、DataGrid1_UpdateCommand（修改保存）下写你的操作代码

F9 2004-10-14

打赏
举报

简单的
叶面
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="SelectDatagrid.aspx.vb" Inherits="CreateControl.SelectDatagrid"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>SelectDatagrid</title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<div id="tt">
<asp:DataGrid id="DataGrid1" runat="server">
<Columns>
<asp:ButtonColumn Text="选择" CommandName="Select"></asp:ButtonColumn>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="编辑"></asp:EditCommandColumn>
</Columns>
</asp:DataGrid>
<asp:Button id="Button1" runat="server" Text="Button"></asp:Button>
</div>
</form>
</body>
</HTML>
代码
Imports System.Data
Imports System.Data.SqlClient
Public Class SelectDatagrid
Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Button1 As System.Web.UI.WebControls.Button

'注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
If Page.IsPostBack = False Then
bind()
End If
End Sub

Private Sub bind()
Dim myconn As New SqlConnection("server=(local);DataBase=pubs;uid=sa;pwd=sa")
Dim mycomm As New SqlDataAdapter("SELECT * FROM jobs", myconn)
Dim ds As New DataSet
mycomm.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End Sub

Private Sub DataGrid1_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.CancelCommand
DataGrid1.EditItemIndex = -1
bind()
End Sub

Private Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand
DataGrid1.EditItemIndex = e.Item.ItemIndex
bind()
End Sub

Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
e.Item.Attributes.Add("onclick", Page.GetPostBackClientEvent(e.Item.Cells(1).Controls(0), ""))
End If
End Sub
End Class

huangbznet 2004-10-14

打赏
举报

TO: F9(寒冬之夜)
有没有写的详细一点的，用vb.net写的！解决的话马上给分的！

F9 2004-10-14

打赏
举报

看一下孟老大的
http://dotnet.aspx.cc/ShowDetail.aspx?id=8ADE535F-AD40-4DE3-A962-A64B4FAF12C4

huangbznet 2004-10-14

打赏
举报

有没有跟数据库有关的范例啊！

softchao 2004-10-14

打赏
举报

ASP.NET快速入门教程里面都有的！你看看然后根据自己的需求去做就可以了

huangbznet 2004-10-14

打赏
举报

请各位高手帮帮忙啊！

huangbznet 2004-10-14

打赏
举报

楼上哪位有范例可以让我参考参考啊！

wangdequan1024 2004-10-14

打赏
举报

设置三个按钮的CommandName，如下：
<asp:TemplateColumn HeaderText="操作">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle"></HeaderStyle>
<ItemTemplate>
<asp:LinkButton Text="修改" CommandName="edit" ForeColor="blue" runat="server" ID="Linkbutton2" />
<asp:LinkButton Text="删除" CommandName="delete" ForeColor="blue" runat="server" ID="Linkbutton1" />
<asp:LinkButton Text="选择" CommandName="select" ForeColor="blue" runat="server" ID="Linkbutton3" />
</ItemTemplate>
</asp:TemplateColumn>

分别调用DataGrid的EditCommand、DeleteCommand、ItemCommand事件来处理
如下：
private void MyDataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string sql="delete from metting_apply where metting_type_no='"+Convert.ToInt32(e.Item.Cells[0].Text)+"' and metting_apply_no='"+e.Item.Cells[2].Text.ToString()+"'";
Public_Class.Execute_Command(sql);
DataShow();
}
private void MyDataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Response.Redirect("metting_apply_add.aspx?type_no="+Convert.ToInt32(e.Item.Cells[0].Text)+"&apply_no="+e.Item.Cells[2].Text.ToString()+"&action=edit");
}
private void MyDataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(CommandName=="select")
{ //代码}
}

vkuja2003 2004-10-14