how can i update an access database

Question

how can i update an access database with data from textbox

Kirtan Patel · Answer

Friend Here is sample code for Updating Access Database just take reference of it :) i have commented the code for your understanding .. if still you have doubt then let me know :) i will help you. if my answer helps you then dont forget to check do you like this answer check box :) using System.Data.OleDb; private void Updatebutton1_Click( object sender EventArgs e) { string yourValueForField = test ; //Connection String OleDbConnection con = new OleDbConnection ( @Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Database1.accdb;Persist Security Info=True ); //Open the Connection con.Open(); OleDbCommand comm = new OleDbCommand ( update TableName set Username=@username where id=5  con); comm.Parameters.AddWithValue( @username  yourValueForField); //Execute the Query on Database comm.ExecuteNonQuery(); //Close the Connection con.Close(); }