After deleted records datagridview1 not updated or refresh?

Question

0.00/5 (No votes)

See more:

Hi,

I try to delete the records and it was successfully deleted but datagridview1 not updated or refreshed

Help me on this....

What I have tried:

Private Sub Button8_Click(sender As Object, e As EventArgs) Handles Button8.Click
       Dim CODE As String

       CODE = txtCode.Text

       Try
           sql = "delete from SONGS where CODE = ? "
           ConnD()
           cmd = New OleDbCommand(sql, conn)

           cmd.Parameters.AddWithValue("CODE", CODE)
           cmd.ExecuteNonQuery()
           Console.WriteLine(Command)
           MsgBox("Deleted", MsgBoxStyle.Information)
           Form_Load()

           conn.Close()

       Catch ex As Exception
           MessageBox.Show(ex.Message)


       End Try
   End Sub

Posted 21-Feb-20 23:28pm

Member 14621280

Updated 22-Feb-20 2:14am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2020-02-21T23:43:00

Solution 1

You are only deleting from the database. You need to rebind the source data and the DataGridView, and tell the view that it should refresh itself.

And you should not be calling Form_Load from inside a handler on the form.

Posted 21-Feb-20 23:43pm

Richard MacCutchan

Updated 21-Feb-20 23:44pm

v2

Comments

Member 14621280 22-Feb-20 6:01am

Dim CODE As String

CODE = txtCode.Text

Try
sql = "delete from SONGS where CODE = ? "
ConnD()
cmd = New OleDbCommand(sql, conn)

cmd.Parameters.AddWithValue("CODE", CODE)
cmd.ExecuteNonQuery()
Console.WriteLine(Command)
MsgBox("Deleted", MsgBoxStyle.Information)
DataGridView1.Refresh()

conn.Close()

Catch ex As Exception
MessageBox.Show(ex.Message)

but itwont work

Richard MacCutchan 22-Feb-20 7:09am

Of course it won't work, because your in memory DataSource has not been updated. Where is the DataGridView getting its information from?

Member 14621280 22-Feb-20 7:55am

i have used load_data()
but no use

Richard MacCutchan 22-Feb-20 8:09am

What does that mean?

Member 14621280 22-Feb-20 8:12am

Public Sub Form_Load()

LD()

End Sub
Public Sub LD()
ConnD()
sql = "select CODE,ETITLE,TTITLE,SONGT,SONGE from SONGS"
cmd = New OleDbCommand(sql, conn)
da = New OleDbDataAdapter(sql, conn)
da.Fill(dt)
bs.DataSource = dt
dr = cmd.ExecuteReader()
DataGridView1.DataSource = bs
DataGridView1.Columns(2).Visible = False
DataGridView1.Columns(3).Visible = False
DataGridView1.Columns(4).Visible = False
DataGridView1.Columns(0).AutoSizeMode = DataGridViewAutoSizeColumnMode.None
DataGridView1.Columns(1).AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill

conn.Close()
End Sub

Richard MacCutchan 22-Feb-20 8:16am

See link below about how to use a DataAdapter to automate the changes.

Member 14621280 22-Feb-20 7:56am

can u explain please

Richard MacCutchan 22-Feb-20 8:12am

How do you populate the DataGridView in the first place? You need to think about the logic of your application. Any changes to your database will only be shown in the DataGridView by reading all the records again, or using a DataAdapter. But I have no idea how your application is designed or coded.

Member 14621280 22-Feb-20 8:15am

yes exactly i have just created reading records datagridview

Richard MacCutchan · Answer 2 · 2020-02-22T02:15:00

Solution 2

Populating a DataSet from a DataAdapter - ADO.NET | Microsoft Docs[^]

Posted 22-Feb-20 2:15am

Richard MacCutchan