send me data grid example?
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
‘Put user code to initialize the page here
If Not Page.IsPostBack Then
opencon()
End If
End Sub
Private Sub DataGrid1_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.CancelCommand
DataGrid1.EditItemIndex = -1
opencon()
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
opencon()
End Sub
Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
opencon()
Dim str As String
cmd.Connection = con
str = e.Item.Cells(0).Text
cmd.CommandText = “delete stud where name=@n”
cmd.Parameters.Add(”@n”, SqlDbType.VarChar).Value = str
cmd.ExecuteNonQuery()
DataGrid1.EditItemIndex = -1
opencon()
End Sub
Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
Dim nname As String
Dim nrno As Int32
Dim nclass As String
opencon()
nname = e.Item.Cells(0).Text
nrno = Convert.ToInt32(CType(e.Item.Cells(1).Controls(0), TextBox).Text)
nclass = CType(e.Item.Cells(2).Controls(0), TextBox).Text
cmd.Connection = con
cmd.CommandText = “update stud set rno=@r,class=@c where name=@na”
cmd.Parameters.Add(”@na”, SqlDbType.VarChar).Value = nname
cmd.Parameters.Add(”@r”, SqlDbType.Int).Value = nrno
cmd.Parameters.Add(”@c”, SqlDbType.VarChar).Value = nclass
cmd.ExecuteNonQuery()
DataGrid1.EditItemIndex = -1
opencon()
End Sub
Sub opencon()
con.ConnectionString = “server=HOME;Integrated Security=True;Database=EMP”
con.Open()
Dim adp As New SqlDataAdapter(”select * from stud”, “server=HOME;Integrated Security=True;Database=EMP”)
Dim ds As New DataSet
adp.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
End Sub
End Class
THis is the basic program to edit,delete the data from datagrid.
Extreme Makeover, PeopleSoft Edition – Part 1
