Windows Form Databinding in C# with BindingNavigator

In my previous tutorial which I used Windows Form Databinding in VB.NET to bind data and Customized BindingNavigator component as I used Buttons instead the default BindingNavigator component that enable you to Add, Delete, Update, Retrieve, and Search record.

Actually, it was already done this program before in VB.NET (see How to use BindingNavigator in VB.NET). As a challenge, I migrate VB.NET to C – Sharp (C#) to do this job where in the functions can perform to Add, Delete, Update, Retrieve, and Search record, and most probably all functions and design are almost identical in my previous tutorials. In fact, the code in C# not too far from the code of VB.NET.  However, there are some lines of code that you need to understand it well because of some instances. Let say, to Startup Form. Usually, in VB.NET, we go to Project Menu – Windows Application Properties – and set Startup Form which form will be loaded first. In C#, to set the Startup Form you need to double click the Program.cs on your Solution Explorer. This code generated looks like this:

 static void Main()

        {

            Application.EnableVisualStyles();

            Application.SetCompatibleTextRenderingDefault(false);

            Application.Run(new frmHome());

        }

To change the Startup Form, you only change frmHome name in which Form you want to load first. Note, the default name of every forms are Form1, Form2, Formn every time you add new Windows Form. It’s better to change the name of every Forms to make it readable and meaningful.

The experience I had while using C# is how to show Form. Before, I can’t find a solution how to work it because in VB is very simple to show Form. This is how:

 Form frm = new frmAdd();

        frm.ShowDialog();

You cannot do (Form1.ShowDialog()) like VB to show form. Instead, initialize first to enable to show other forms.

Those are among few line of codes might take to remember while working in C# if you are VB.NET programmers expertise.

Now, let’s explore the source code:

Code for Add New Entry:

private void btnsave_Click_1(object sender, EventArgs e)

{

  this.Validate();

  this.tblinfoBindingSource.EndEdit();

  this.tblinfoTableAdapter.Update(this.dbInfoDataSet.tblinfo);

  MessageBox.Show("New Records has been successfully saved", "Save Record",    

  MessageBoxButtons.OK, MessageBoxIcon.Information);

  this.tblinfoBindingSource.AddNew();

}

Code for Update Records:

private void btnupdate_Click(object sender, EventArgs e)

{

  this.Validate();

  this.tblinfoBindingSource.EndEdit();

  this.tblinfoTableAdapter.Update(this.dbInfoDataSet.tblinfo);

  MessageBox.Show("Records has been successfully updated", "Update Records",    

  MessageBoxButtons.OK, MessageBoxIcon.Information);

}

The code for Add and Update works in the same way as you have noticed.

Code for Delete Records:

private void btndelete_Click(object sender, EventArgs e)

{

     int x;

     string fname;

     string lname;

     x = this.tblinfoDataGridView.Rows.IndexOf(this.tblinfoDataGridView.CurrentRow);

     fname = this.tblinfoDataGridView.Rows[x].Cells[0].Value.ToString();

     lname = this.tblinfoDataGridView.Rows[x].Cells[1].Value.ToString();

     if (MessageBox.Show("You want to delete" + fname + " " + lname + " records?", "Confirm 

        Entry", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == 

        System.Windows.Forms.DialogResult.Yes)

     {

        this.tblinfoBindingSource.RemoveAt(this.tblinfoBindingSource.Position);

        this.tblinfoTableAdapter.Update(this.dbInfoDataSet.tblinfo);

        MessageBox.Show(fname + " " + lname + " " + "record has been successfully deleted");

     }

     else

     {

        MessageBox.Show("Cancelled","Cancelled 

        Entry",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);

     }

}

Code for Retrieve Records:

  this.tblinfoTableAdapter.Fill(this.dbInfoDataSet.tblinfo);

Code for Search Records:

private void txtsearch_TextChanged(object sender, EventArgs e)

{

  this.tblinfoBindingSource.Filter = "Firstname LIKE '%" +txtsearch.Text + "%' OR Lastname 

  LIKE '%" + txtsearch.Text + "%'";

}

The screenshots are almost identical in my previous article. Download this source code here. If you want to save more files online and share it to your friends, sign up for free.