prjDataSetTableAdapters.tblProjectsDataTableAdapter tblProjectsDataAdapter = new prjDataSetTableAdapters.tblProjectsDataTableAdapter();
            using (OleDbConnection conn = new OleDbConnection(tblProjectsDataAdapter.Connection.ConnectionString))
            {
                conn.Open(); 
                using (OleDbCommand cmd = new OleDbCommand("UPDATE tblProjectsData SET ProjectName = @ProjectName WHERE id = @id"))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Connection = conn;
                    cmd.Parameters.AddWithValue("@ProjectName", "893457893453563785").OleDbType = OleDbType.VarChar;
                    cmd.Parameters.AddWithValue("@id", 1).OleDbType = OleDbType.Integer;
                    var recordsUpdated = cmd.ExecuteNonQuery(); 
                }
                conn.Close();
            }