Delete a selected row from datagrid in vb.net

[jeccinta]

Hi,
Am a newbie to vb.net...Can u tell me how to delete a selected row in datagrid aon click of a button ???

[syedwna]

<asp:TemplateCo lumn>
<HeaderStyle CssClass="listh eader" />
<HeaderTemplate >
view
</HeaderTemplate>
<ItemStyle CssClass="listC olumnText" />
<ItemTemplate >
<a href='view.aspx ?bcId=<%# DataBinder.Eval (Container.Data Item, "ForumTopic_id" )%>' target="_blank" >
<img alt="" src="images/icon_delete.gif " height="15" style="border: 0;"></a>
</ItemTemplate>
</asp:TemplateCol umn>

[nmsreddi]

hi

If you want to delete a row in a data grid first add a delete button from property builder and in that select columns options in that you will find delete button just add that first and then you have code your delete query in the codebehind.bett er try to add buttons from html code rather than design view


reghards
nmsreddi

[anonymous]

Question was for vb.net not asp.net

[yellagiri]

To delete a selected row from DataGrid using VB.NET

delete * from [TableName] where ID="+DataGridVi ew1.CurrentRow. Cells(0).Value+ "

[karthickbabu]

Hi,
Am a newbie to vb.net...Can u tell me how to delete a selected row in datagrid aon click of a button ???

Click the rowheader in data grid view then press delete button in keyboard
U select currect row as below from data table

Dim Dr As DataRow
Dr = DtSalesReport.R ows.Item(dgvSal esReport.Curren tRow.Index)
Dr.Delete()
DtSalesReport.A cceptChanges()

[yukimasaki]

karthickbabu try this


Dim Connection As New OleDb.OleDbConn ection
Dim dbProvider As String = "Provider=Micro soft.ACE.OLEDB. 12.0;Jet OLEDB:Database Password=cSSO3s EEhrM4vY3je0qC; " 'connect to the access 2010 database, including DB Password
Dim dbSource As String = "Data Source = C:\sys(Q)\db's\ TGBTG1.accdb"
Connection.Conn ectionString = dbProvider & dbSource
Connection.Open ()
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(d t)
Dim da As New OleDbDataAdapte r
da = New OleDbDataAdapte r("select * from buy where Qu_id=" & Quotation_IDLab el1.Text, Connection)
da.Fill(dt)
Dim i As Integer
i = DataGridView1.C urrentRow.Index
dt.Rows(i).Begi nEdit()
dt.Rows(i).Dele te()
dt.Rows(i).EndE dit()

Dim cb As New OleDbCommandBui lder(da)

da.Update(dt)

DataGridView1.D ataSource = dt.DefaultView
Connection.Clos e()