We will know how to insert records to database and show one column of inserted items into a listbox. Here we use two textboxes, button and a ListBox. And after adding items it is automatically loaded to the ListBox.

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;

namespace After_add_new_item_reload_listbox

{

public partial class Form1 : Form

{

SqlConnection con = new SqlConnection(@"server = HOME-SAT/SQLEXPRESS;data source = .; initial catalog = test; user id=sa;pwd =pintu ;integrated security = SSPI");

SqlCommand com;

SqlDataAdapter sqlda;

DataSet ds;

string str;

DataTable dt;

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

listboxbind();

}

private void listboxbind()

{

con.Open();

str = "select * from employee";

com = new SqlCommand(str, con);

sqlda = new SqlDataAdapter(com);

ds = new DataSet();

sqlda.Fill(ds, "employee");

dt = ds.Tables["employee"];

listBox1.DisplayMember = "empid";

listBox1.ValueMember = "empname";

listBox1.DataSource = ds.Tables["employee"];

con.Close();

}

private void btn_add_Click(object sender, EventArgs e)

{

com = new SqlCommand();

com.Connection = con

com.CommandType = CommandType.Text;

com.CommandText = "insert into employee values(@empid,@empname)";

com.Parameters.Clear();

com.Parameters.AddWithValue("@empid", txt_id.Text);

com.Parameters.AddWithValue("@empname", txt_name.Text);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

MessageBox.Show("Data entered successfully!!!");

listboxbind();

clear();

}

private void clear()

{

txt_id.Text = "";

txt_name.Text = "";

}

}

}