Load data in windows form without closing form

See more:

C#

SQL-Server

SQL-Server-2008

Hi,

I am having a problem. I am using SQL Server 2008 as my DB. Everything is okay loading, adding, data.

Problem is when i insert a record in database. After inserting a record, it does not show properly in the form unless i close the form and reload it again. Is there any method in C# by which we can refresh the table and can load it in the form same time without restarting the form?

Thanks
//This is My code//

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;

namespace MyProject
{

public partial class Form1 : Form
{
DataTable tbl = new DataTable();
int i = 0;

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\manish\Documents\HRM.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
conn.Open();
SqlCommand command = new SqlCommand("select * from emp_detail", conn);
SqlDataAdapter adp = new SqlDataAdapter(command);
adp.Fill(tbl);
display(tbl);


}
private void display(DataTable tbl)
{
txtempid.Text = tbl.Rows[i][0].ToString();
txtname.Text = tbl.Rows[i][1].ToString();
txtsurname.Text = tbl.Rows[i][2].ToString();
txtfathername.Text = tbl.Rows[i][3].ToString();
dtdob.Text = tbl.Rows[i][4].ToString();
cbgender.Text = tbl.Rows[i][5].ToString();
cbcity.Text = tbl.Rows[i][6].ToString();
txtcontactno.Text = tbl.Rows[i][7].ToString();
dtdoj.Text = tbl.Rows[i][8].ToString();
txtdept.Text = tbl.Rows[i][9].ToString();
txtdesig.Text = tbl.Rows[i][10].ToString();
txtqualification.Text = tbl.Rows[i][11].ToString();
rtaddress.Text = tbl.Rows[i][12].ToString();
rtremarks.Text = tbl.Rows[i][13].ToString();

}
private void button4_Click(object sender, EventArgs e)

{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\manish\Documents\HRM.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
conn.Open();
SqlCommand command = new SqlCommand();
command.CommandText = "insert into emp_detail(empid,name,surname,fathername,dob,gender,city,contactno,doj,department,designation,qualification,address,remarks) values('" + txtempid.Text + "','" + txtname.Text + "','" + txtsurname.Text + "','" + txtfathername.Text + "','" + dtdob.Text + "','" + cbgender.Text + "','" + cbcity.Text + "','" + txtcontactno.Text + "','" + dtdoj.Text + "','" + txtdept.Text + "','" + txtdesig.Text + "','" + txtqualification.Text + "','" + rtaddress.Text + "','" + rtremarks.Text + "')";
command.Connection = conn;
command.ExecuteNonQuery();
MessageBox.Show("Saving is done!");
}