C # Implementation exports data already displayed in the ListView to an Access database

private void Button1_Click (object sender, EventArgs e)
{
OleDbConnection dbconn = new OleDbConnection (@ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\a.mdb");
Dbconn. Open ();

foreach (ListViewItem lvi in Lvlogs.items)//traverse the entire ListView to export data from the ListView to the database
{
Cmd. Parameters.clear ();
String strUserID = "", Strcheckmode = "", Strinoutmode = "", strdate = "";
int Ngrade;

strUserID = Lvi. SUBITEMS[1]. Text;
Strcheckmode = Lvi. SUBITEMS[2]. Text;
Strinoutmode = Lvi. SUBITEMS[3]. Text;
Strdate = Lvi. SUBITEMS[4]. Text;

Ngrade = Convert.ToInt16 (Strcheckmode);

String cmdstring = "INSERT into see ([Employee id],[test mode],[Access status],[Date]) VALUES ('" + strUserID + "', '" + Ngrade + "', '" + STRINOUTMO De + "', '" + strdate + "')";

OleDbCommand cmd = new OleDbCommand ();
Cmd. Connection = Dbconn;
Cmd.commandtext = cmdstring;
Cmd. ExecuteNonQuery ();
Cmd. Dispose ();
}
To close a connection to a database
Dbconn. Close ();
MessageBox.Show ("Export completed");
Dbconn. Dispose ();

}

C # Implementation exports data already displayed in the ListView to an Access database