Delete A Record From Datatable and Bind DataGrid

Question

Dear Team, I need help. My Requirement is - 1. On Page Load, Bind the DataGrid - Done. 2. There are 2 buttons -"Add New" and "Edit". "Add New" -> Add a new row in datagrid - Done "Edit" -> Edit values in Datagrid - Done 3. There is a "Delete" button in Datagrid -> Done 4. On clicking "Delete" button, that particular row must be removed. Logic - If that row is already there in the database, remove from the database and bind the grid. - Done. If that record is newly add by clicking on "Add New" button and not in Database, remove that record from datatable and bind the Datagrid - NEED HELP. ------------ My Code is as below- -------- ASPX Page -
-----------------------
------------------------------
aspx.vb Page
------------------------
'''
''' Delete - Ultimate Holding Company
'''
'''
Private Sub dgUltimateHoldingCompany_ItemCommand(ByVal source As Object, ByVal e As DataGridCommandEventArgs) Handles dgUltimateHoldingCompany.ItemCommand
Try
fn_db()
Dim srno As Integer
srno = e.Item.Cells(0).Text
Dim rowid As String
rowid = e.Item.Cells(1).Text
Dim sql As String
Dim res As String = String.Empty
If rowid <> " " Then
sql = "update ril_mis_ultimateholding set delete_flag = 1 where row_id =" + rowid
res = lobjDatabase.BySingleValue(sql)
GetDataUltimateHoldingCompany()
ElseIf rowid = " " Then ''Delete Record From Datatable.
Dim dtUltimateHoldingCompanyDel As DataTable = CType(Me.ViewState("_dataUltimateHoldingCompany"), DataTable)
Dim drow As DataRow()
drow = dtUltimateHoldingCompanyDel.Select("srnoUltimateHoldingCompany_=" + srno.ToString())
For i As Integer = 0 To drow.Length - 1
dtUltimateHoldingCompanyDel.Rows.Remove(drow(i))
Next
Me.ViewState.Add("_dataUltimateHoldingCompany", dtUltimateHoldingCompanyDel)
dgUltimateHoldingCompany.DataSource = dtUltimateHoldingCompanyDel
dgUltimateHoldingCompany.DataBind()
End If
Catch ex As Exception End Try End Sub
------------------
Private Sub dgUltimateHoldingCompany_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgUltimateHoldingCompany.ItemDataBound
fn_db()
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
Dim ddlEntitiesUltimateHoldingCompany As DropDownList
Dim txtdrowidUltimateHoldingCompany As TextBox
ddlEntitiesUltimateHoldingCompany = CType(e.Item.FindControl("ddlEntitiesUltimateHoldingCompany"), DropDownList)
' txtdPercentageUltimateHoldingCompany = CType(e.Item.FindControl("txtdPercentageUltimateHoldingCompany"), TextBox)
txtdrowidUltimateHoldingCompany = CType(e.Item.FindControl("txtdrowidUltimateHoldingCompany"), TextBox)
'txtHoldingcompanyAdddate = CType(e.Item.FindControl("txtHoldingcompanyAdddate"), TextBox)
'' Fill Entities List
ddlEntitiesUltimateHoldingCompany.DataSource = Session("dsUltimateHoldingCompany")
ddlEntitiesUltimateHoldingCompany.DataValueField = "e_code"
ddlEntitiesUltimateHoldingCompany.DataTextField = "e_name"
ddlEntitiesUltimateHoldingCompany.DataBind()
ddlEntitiesUltimateHoldingCompany.Items.Insert(0, Selectstring) If Not (DataBinder.Eval(e.Item.DataItem, "ultimatecode") Is DBNull.Value) Then
Dim i1 As Integer = ddlEntitiesUltimateHoldingCompany.Items.IndexOf(ddlEntitiesUltimateHoldingCompany.Items.FindByValue(e.Item.DataItem("ultimatecode")))
ddlEntitiesUltimateHoldingCompany.SelectedIndex = i1 ddlEntitiesUltimateHoldingCompany.Enabled = False
Else
ddlEntitiesUltimateHoldingCompany.SelectedIndex = 0
End If
If Not (DataBinder.Eval(e.Item.DataItem, "rowidUltimateHoldingCompany") Is DBNull.Value) Then
txtdrowidUltimateHoldingCompany.Text = (e.Item.DataItem("rowidUltimateHoldingCompany").ToString())
txtdrowidUltimateHoldingCompany.Enabled = False
End If
End If
End Sub
-----------------------
Private Sub btnaddUltimateHoldingCompany_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnaddUltimateHoldingCompany.Click
SaveScreenDataUltimateHoldingCompany()…

Arun Kumar Tiwari · Answer

Visit on link :
https://www.ittutorialswithexample.com/2015/01/insert-update-and-delete-record-in-datagridview-csharp.html

Mageshwaran R · Answer

Hi, Try this code:  protected   void  OnRowDeleting( object  sender, GridViewDeleteEventArgs e)      {                     int  deleteR= Convert.ToInt32(grid1.DataKeys[e.RowIndex].Values[0]);          sqlconnection sqlcon= new  sqlconnection();          SqlCommand sqlcmnd  =  new  SqlCommand ( "Delete FROM yourdatabase Where yourID = @yourID"           sqlcmnd.Parameters.AddWithValue( "@yourID" , yourID);         sqlcmnd.Exectenonquery();      }

Riddhi Valecha · Answer

Dear Team,

Thanks a ton for your help ...

My logic is -

1. On Page Load, bind the datagrid with data from database - done.

2. There are "Add New" and "Edit" buttons below the datagrid.

3. On Clicking "Add New" button - A new row is added to the datagrid.

4. Issue is - I have 3 records in the database, those are fetched from the database.

Next, I click on "Add New" button and add 3 more rows in the datagrid.

So, total now I have is 6 records -

Record - 1 - from database

Record - 2 - from database

Record - 3 - from database

Record - 4 - "Add New" Button

Record - 5 - "Add New" Button

Record - 6 - "Add New" Button

-----

Now, If I try to delete Record -5 ("Add New" Button) , then next time when the datagrid binds, it binds the records - 1,2,3,4.

The last record - 6 does not get bind with the datagrid.

Anand Navale · Answer

To iterate through a DataTable and remove rows conditionally (eg: row having column_id as 16), you can use the following code: Dim  iterateIndex  As   Integer  = 0   Dim  newDataTable  As  DataTable = originalDataTable.Copy   For   Each  row  As  DataRow  In  newDataTable.Rows   If  row( "column_id" ) = 16  Then    originalDataTable.Rows.RemoveAt(iterateIndex)   Else    iterateIndex += 1   End   If    Next

Sonu Gupta · Answer

Hi,   Visit the below links -    https://www.aspsnippets.com/Articles/Remove-Delete-Last-Blank-Empty-Row-from-DataGridView-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx   https://www.ittutorialswithexample.com/2015/01/insert-update-and-delete-record-in-datagridview-csharp.html

Ali Tuna · Answer

To delete rows from datatable, you could use the logic like this:
Use the select function on the datatable to filter the rows that match your condition and this will return an array of Datarows.
Then use a for each loop and remove each row from the Array of Datarows using datatable.Rows.Remove(row)