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