show a message when new row added to datagridview

Question

0.00/5 (No votes)

See more:

Hey

I have a windows form application(See below) in which I have a datagridview.

I have linked the datagridview to a sql database.

I added a timer for my application to update the datagridview with new records from the database.

Now I would like to display a message (alert) to the user only when new rows are added to the datagridview and it should not stop the win form application from running.

How can I do this please?

Thanks

This is my windows form application so far:

C#

{

    public partial class Form1 : Form
    {
        Timer timer = new Timer();

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
 
            this.CarUpdateTableAdapter.Fill(this.mySQLDataSource.CarUpdate);

            this.dataGridView1.Sort(this.dataGridView1.Columns[18], ListSortDirection.Descending);
            dataGridView1.AutoResizeColumns();

            timer.Interval = 300000;
            timer.Tick += new EventHandler(UpdateDataGridView);
            timer.Start();

        }

        private void UpdateDataGridView(object sender, EventArgs e)
        {
            this.CarUpdateTableAdapter.Fill(this.mySQLDataSource.CarUpdate);
        }


    }
}

Posted 21-Jul-14 2:11am

xirokx

Add a Solution

3 solutions

Solution 3

It is an event it will be called automatically when new rows are added.....

by using the following code u can drop the event and enable the event for row added

..................
So when datagridview is loaded for the first time make sure to drop the event.soon after loading
enable the even again
..................
//event Drop

C#

this.dataGridView1.RowsAdded -= new System.Windows.Forms.DataGridViewRowsAddedEventHandler(this.dataGridView1_RowsAdded);

//event enable

C#

this.dataGridView1.RowsAdded += new System.Windows.Forms.DataGridViewRowsAddedEventHandler(this.dataGridView1_RowsAdded);

Posted 22-Jul-14 0:05am

Harish Sady

Updated 22-Jul-14 0:11am

v2

Comments

VICK 23-Jul-14 0:34am

Use "Improve Solution" option at bottom of your first solution to edit it, rather than posting multiple 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)

Harish Sady · Accepted Answer · 2014-07-21T02:45:00

Solution 1

C#

private void grd_movement_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
       {
           MessageBox.Show("Your Message here");// it is better to show u r message in a label .....

       }

Posted 21-Jul-14 2:45am

Harish Sady

Comments

xirokx 21-Jul-14 9:06am

thanks for your response,

where in my code do I place your method?

surely I have to check first if rows are being added and only call your method if new rows are being added?

pls clarify

thanks

Harish Sady · Accepted Answer · 2014-07-21T17:57:00

Solution 2

Its a event ...Just select the datagridview and go to properties and select event tab.....
There u will see RowAdded event ....double click it and add the code

Posted 21-Jul-14 17:57pm

Harish Sady

Comments

xirokx 22-Jul-14 3:45am

public partial class Form1 : Form
{
Timer timer = new Timer();

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
this.CarUpdateTableAdapter.Fill(this._SAC_OTPDataSet.CarUpdate);

this.dataGridView1.Sort(this.dataGridView1.Columns[18], ListSortDirection.Descending);
dataGridView1.AutoResizeColumns();

timer.Interval = 60000;
timer.Tick += new EventHandler(UpdateDataGridView);
timer.Start();
}

private void UpdateDataGridView(object sender, EventArgs e)
{

this.CarUpdateTableAdapter.Fill(this._SAC_OTPDataSet.CarUpdate);

}

private void dataGridView1_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
MessageBox.Show("New Cars Added:");
}

}

okay so my code looks like this....

On Form Load the messageBox is first shown 4-5 times, even if its not adding new records so I keep pressing accept to see datagridview. This is not how it should work.

My aim is for a messageBox to be displayed ONLY when the datagridview is refreshed as the database it gets its values from is updated every 5-6mins and sometimes there is new data and sometimes not. In the event there is new data I would like a messagebox to show up.

Please can you correct my code to enable this to happen?

Thanks in advance

xirokx 22-Jul-14 5:11am

Ahh, to solve this I went into Form1.Designer.cs file and removed the line:

this.dataGridView1.RowsAdded += new System.Windows.Forms.DataGridViewRowsAddedEventHandler(this.dataGridView1_RowsAdded);

I then added the same line to my Form1.cs file, which checks for new records NOT when the form loads but every 4-5minutes afterwards and alerts user if new records have been added.

Thanks for your help, really appreciate it.