DataGrid With Edit Button VB .NET Program



Description:
           
          The button is added in the data grid column. We will see how display and save data from a database. It will also show how we can edit, delete the data in database through data grid.

Imports System.Windows.Forms
Imports System.Data
Imports System.Data.SqlClient
Public Class griddb
    Dim con As New SqlConnection
    As New SqlCommand
    Dim da As New SqlDataAdapter
    Dim ds As New DataSet
Private Sub griddb_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
       
        Me.Orderdetails2TableAdapter.Fill(Me.ShoppingtrollyDataSet.orderdetails2)
       
        con = New SqlConnection("DataSource=COMPUTER10;Initial Catalog=sample;Integrated Security=True")
        con.Open()
        cmd = New SqlCommand("select * from books", con)
        da = New SqlDataAdapter(cmd)
        da.Fill(ds)
        DataGridView1.DataSource = ds
        'DataGridView1.DataBindings()
        con.Close()
    End Sub
protected void Item_Click(Object sender, DataGridCommandEventArgs e)
         Dim pid,cid As New SqlConnection
        TableCell id = e.Item.Cells(1)
       pid = id.Text;
        TableCell idd = e.Item.Cells(0)
        cid = idd.Text;
cmd = New SqlCommand ("deleterecords1", con);
        cmddel.CommandType = CommandType.StoredProcedure;
        cmddel.Parameters.Add(new SqlParameter("@id", SqlDbType.VarChar, 20))
        cmddel.Parameters("@id").Value = pid;
        cmddel.Parameters.Add(new SqlParameter("@idd", SqlDbType.VarChar, 20))
        cmddel.Parameters("@idd").Value = cid;
        con.Open();
        cmddel.ExecuteNonQuery();
        con.Close();
  End Class


OUTPUT


Contact:
Mr. Roshan P. Helonde
Mobile: +91-7276355704
WhatsApp: +91-7276355704

Email: roshanphelonde@rediffmail.com
Share:

Total Pageviews

CONTACT US

Prof. Roshan P. Helonde
Mobile: +917276355704
WhatsApp: +917276355704
Email: roshanphelonde@rediffmail.com

Enter Project Title

Popular Projects

All Archive

Contact Form

Name

Email *

Message *