In this blog we will know how to Insert update delete navigate using textbox and display result in listview.
App.config
<?xml
version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="dsn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=..\EMP.mdb" />
</appSettings>
</configuration>
Form1.cs
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.OleDb;
namespace
Insert_update_delete_navigate
{
public partial
class Form1 :
Form
{
string ConnectionString =
System.Configuration.ConfigurationSettings.AppSettings["dsn"];
OleDbCommand com;
OleDbDataAdapter oledbda;
string str;
DataSet ds;
byte flag;
BindingManagerBase bm;
DataTable dt;
public Form1()
{
InitializeComponent();
}
private void
Form1_Load(object sender,
EventArgs e)
{
listView1.Columns.Add("ID", 70,
HorizontalAlignment.Center);
listView1.Columns.Add("NAME", 70,
HorizontalAlignment.Center);
listView1.View = View.Details;
listView1.GridLines = true;
listView1.BackColor = Color.Aqua;
listView1.ForeColor = Color.Blue;
OleDbConnection con =
new OleDbConnection(ConnectionString);
con.Open();
str = "select * from student";
com = new
OleDbCommand(str, con);
oledbda = new
OleDbDataAdapter(com);
ds = new
DataSet();
oledbda.Fill(ds, "student");
textBox1.DataBindings.Add("Text",
ds, "student.id");
textBox2.DataBindings.Add("Text",
ds, "student.name");
bm = this.BindingContext[ds,
"student"];
con.Close();
listviewdisplay();
}

Join the conversation! Your thoughts help the community grow.